User Tools

Site Tools


databases:cheatsheet

This is an old revision of the document!


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

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki