###MySQL Stuff
log in as root user: mysql -u root -p (this will then prompt you for a password)
note: if running a command in the mysql prompt produces a -> this probably means that we have failed to insert a semicolon at the end of the line.
show databases;
create database <database-name>;
use <database-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>;
insert into <table-name> (<columnA>, <columnB>) values('Go to the store', false);
select * from todos;
all of these things can be done from a GUI program such as Sequel Pro