mySQL reference - items in {} are optional
SHOW DATABASES -show all databases you have access to CREATE DATABASE [database_name] -create a new database USE [database_name] -select a database to use CREATE TABLE [table_name] ([column_name] [column_type], [column_name2] [column_type2]) -create a new table SHOW TABLES -show all tables in a database
DESCRIBE [table_name] -list the properties of a table (including fields & types) LOAD DATA LOCAL INFILE “[filename].txt” INTO TABLE [table_name] -load data from a text file into the table -the columns in the text file and the table need to be the same order
INSERT INTO [table_name] VALUES (‘[column1_value]’,’[column1_value2]’,’[column1_value3]’) -insert values into a table SELECT [what_to_select] {AS [alias name]} FROM [table_name] {[table_alias]} {WHERE [conditions_to_meet]} {ORDER BY [column_name] [DESC]} -select a set of records -DESC == descending order
DELETE FROM [table_name] -delete all records in a table
UPDATE [table_name] SET [column_name] = [value_to_set_to] WHERE [conditions_to_meet] -update a table