SQL Reference / Cheatsheet

Last updated:

Inserting data into a table

only actual fields need be stated (AUTO-INCREMENT fields shouldn't be included, and NULL fields can be omitted).

INSERT INTO <TBL_NAME>(field1,field2,field3) VALUES('value1','value2',42)

Inserting from select

INSERT INTO <TBL_NAME>(field1,field2,field3) SELECT field1,field2,field3 FROM <OTHER_TBL_NAME>

Dialogue & Discussion