CRUD Create (in the world of http => POST) Command: INSERT INTO `table_name` (`column1`, `column2`, `column3`,...) VALUES ("value1", value2, value3,...) Create new row in the table_name, entered value1 in column1, value2 in column2, etc. Retrieve (in the world of http => GET ) Command: SELECT * FROM `tablename` General Usage: Retrieve all rows from tablename Command: SELECT `id` FROM `tablename` Retrieve all rows from tablename but just the id column Command: SELECT * FROM `tablename` WHERE `id` = 1 Retrieve all rows from tablename where the id column has the value 1 Command: SELECT * FROM `tablename` WHERE `id` = 1 OR `category_id` = 1 AND and OR with WHERE to make it specific AND means "both" things be true OR means "either" thing must be true Update (in the world of http => PUT (Browsers don't do this, so we POST) ) UPDATE `tablename` SET `column1`="value1" WHERE `id`=1 Update tablename, column1 to the new value1, in a row where the column `id` has value 1 Delete (in the world of http => DELETE (Browsers don't do this, so we POST) ) DELETE FROM `tablename` WHERE `id` = 1 Delete row from tablename where column id has value 1