Threadeds SQL Cheatsheet

• DELETE

  • DELETE FROM table_name WHERE column_name = some_value

   

• INSERT

  • INSERT INTO table_name ( column_name1, column_name2, ... ) VALUES ( value1, value2, ... )

   

• SELECT

  • SELECT column_name(s) FROM table_name WHERE clause

   

• UPDATE

  • UPDATE table_name SET column_name = new_value WHERE column_name = old_value