01

KEYWORDS:

• UPDATE <tablename>
SET <colname> = <newValue>
WHERE major = <oldValue>;
SELECT * FROM <tablename>;


• DELETE FROM <tablename>;


• DELETE FROM <tablename>
WHERE

02

Comparison operators:

• OR
• = equals
• <> not equal
• > greater than
• < less than
• <= greater or equal to
• >= less than or equal to