sekayasin

/*
 Swift Programming Language Guide
 "A Swift Tour" Solutions
 https://developer.apple.com/library/prerelease/ios/documentation/Swift/Conceptual/Swift_Programming_Language/GuidedTour.html#//apple_ref/doc/uid/TP40014097-CH2-XID_1
 
 These are the solutions to all the "experiments" in the pre-release Swift Programming Guide. 
 You should be able to copy-paste it into your own playground. Let me know if I screwed 
 any of them up, and I'll be happy to update this gist.  
*/

sekayasin

{
	"files":
	{
		"Backbone.js": "http://backbonejs.org/backbone.js",
		"CSS-reset": "http://meyerweb.com/eric/tools/css/reset/reset.css",
		"Less.js": "https://raw.github.com/cloudhead/less.js/master/dist/less-1.3.3.min.js",
		"RegEx: xregexp.com": "http://cdnjs.cloudflare.com/ajax/libs/xregexp/2.0.0/xregexp-min.js",
		"cycle": "http://malsup.github.com/jquery.cycle.all.js",
		"html5shiv": "https://raw.github.com/aFarkas/html5shiv/master/dist/html5shiv.js",
		"infinite_scroll": "https://raw.github.com/paulirish/infinite-scroll/master/jquery.infinitescroll.min.js",

sekayasin

Sublime Text 2 – Useful Shortcuts (PC)

Loosely ordered with the commands I use most towards the top. Sublime also offer full documentation.

Editing

Ctrl+C	copy current line (if no selection)
Ctrl+X	cut current line (if no selection)
Ctrl+⇧+K	delete line
Ctrl+↩	insert line after

sekayasin

Sublime Text 2 – Useful Shortcuts (Mac OS X)

General

⌘T	go to file
⌘⌃P	go to project
⌘R	go to methods
⌃G	go to line
⌘KB	toggle side bar
⌘⇧P	command prompt

sekayasin

CREATE DATABASE profs;
USE profs;

CREATE TABLE professors (
	name varchar(30) NOT NULL,
	specialization varchar(20),
	salary double(8,2),
	CONSTRAINT prof_pk PRIMARY KEY (name));

CREATE TABLE students (

sekayasin

MYSQL
-----------
Run this on the command line. Not in mysql console.
eg. $alberta_makeever: mysql -u root -p user_development << sample.sql

mysql5 -u root -p
enter password:kwame1
mysql> exit;

Create a database on the sql server.