SQL

SQL-92 Standard

• SQL-92 is the official standard. However, many databases do not completely conform to it or at least add something. ISO-site search query.
• SQL-92 Validator: http://developer.mimer.com/validator/parser92/index.tml
• Syntax diagrams: http://www-dbs.inf.ethz.ch/~isk/WS_97/syntax_diagramme/

Insert / Update

I always mix up the Update and Insert Syntax… Here we go:

UPDATE tbl_name [, tbl_name ...] SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition]

INSERT [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),…
or
INSERT [INTO] tbl_name SET col_name={expr | DEFAULT}, ...

As usual, this snip will be of no use. After writing something down, memory usually makes it persistent :-)