databases:cheatsheet
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, ...)
databases/cheatsheet.txt · Last modified: 2023/01/06 09:51 by dimitrij