databases:cheatsheet
This is an old revision of the document!
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
ORDER BY CLAUSE
SELECT column_name(s) FROM table_name
WHERE
column_name operator value
AND/OR
column_name operator value
AND/OR 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, ...)
databases/cheatsheet.1672989042.txt.gz · Last modified: 2023/01/06 08:10 by dimitrij