Table of Contents

Cheat Sheet

Basic

SELECT column_name(s) FROM table_name

WHERE Clause

SELECT column_name(s) FROM table_name
WHERE column_name operator value

AND/OR Operators

SELECT column_name(s) FROM table_name
WHERE 
    column_name operator value
AND/OR
    column_name operator value

ORDER BY Operators

SELECT column_name(s) FROM table_name ORDER BY column_name ASC/DESC

UPDATE Statement

UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value

DELETE Statement

DELETE FROM table_name WHERE column_name = some_value

INSERT INTO Statement

INSERT INTO table_name (column_1, column_2, column_3, ...)
VALUES (value_1, value_2, value_3, ...)