sql language reference

commands
SELECT - get records from a table
INSERT - add a new record to a table
UPDATE - change a record in a table
DELETE - remove a record from a table

SELECT
SELECT `column1`, `column2` …
FROM `table`
WHERE `column1` = 'value1' AND `column2` = 'value2' …
ORDER BY `column1` [ASC|DESC], `column2` [ASC|DESC] …

INSERT
INSERT INTO `table`
SET  
  `column1` = 'value1',
  `column2` = 'value2'
  …

UPDATE
UPDATE `table`
SET
  `column1`='value1',
  `column2`='value2'
  …
WHERE `column1` = 'value1' AND `column2` = 'value2' …

DELETE
DELETE FROM `table`
WHERE `column1` = 'value1' AND `column2` = 'value2' …

OTHERS
<expression> AND <expression>
<expression> OR <expression>
NOT <expression>
<expression> LIKE <expression>

Victoria