###MySQL Stuff

log in as root user: mysql -u root -p (this will then prompt you for a password)

show databases;

create datbase <database-name>;

use <databse-name>;

show tables;

create table <table-name> (id integer PRIMARY KEY AUTO_INCREMENT, description text NOT NULL, completed boolean NOT NULL); (basic formatting here is column name type modifiers, column name type modifiers, etc)

describe <table-name>;

drop table <table-name>;

###Sublime Text 3 Upgrades

• install package control (by running the code in Sublime Text's console). This functionality can be accessed by typing ctrl+shift+p ... and by typing in "install", we will see an option that says "Package Control: Install Package". Selecting this option will give us the ability to install packages.
• install Material Theme using package control, then add the required and recommended JSON parameters to Sublime's user settings.
• install ColorSublime package using package control. We can then use ColorSublime to install a theme, perhaps the Facebook theme by mbixby.
• download Fira Code and update font_face in Sublime's user settings
• Install PackageResourceViewer (with package control). I think this allows us to extract the source code of some installed package so that subsequent updates to the package will not override our customizations.
• Install AdvancedNewFile using package control. Key bindings can be configured by going here: Preferences > Package Settings > AdvancedNewFile > Key Bindings -- User

###Sublime Text 3 Shortcuts

• ctrl+shift+p ... open command palette
• ctrl+p ... browse files
• ctrl+r ... go to symbol (this allows us to jump to class and function definitions)