Data Manipulation

The four basic operations on data in a database:
  1. Create
  2. Read
  3. Update
  4. Delete

The clauses to match the operations above are:

  1. INSERT
  2. SELECT
  3. UPDATE
  4. DELETE

The general syntax of an SQL statement is:

INSERT | SELECT | UPDATE | DELETE
FROM
[WHERE]
[ORDER BY]
[GROUP BY]