StartupWerk

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Cheat Sheet ======

===== Basic =====
<code>SELECT column_name(s) FROM table_name</code>


===== WHERE Clause =====
<code>
SELECT column_name(s) FROM table_name
WHERE column_name operator value
</code>

===== AND/OR Operators =====
<code>
SELECT column_name(s) FROM table_name
WHERE 
    column_name operator value
AND/OR
    column_name operator value
</code>

===== ORDER BY Operators =====
<code>SELECT column_name(s) FROM table_name ORDER BY column_name ASC/DESC</code>

===== UPDATE Statement =====
<code>
UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value
</code>

===== DELETE Statement =====
<code>DELETE FROM table_name WHERE column_name = some_value</code>

===== INSERT INTO Statement =====
<code>
INSERT INTO table_name (column_1, column_2, column_3, ...)
VALUES (value_1, value_2, value_3, ...)
</code>