A Gentle Introduction to

SQL

INSERT, UPDATE and DELETE

How to put records into a table, change them and how to take them out again.


INSERT: Not all fields need be specified. Default values may be specified in the CREATE TABLE clause - otherwise NULL is used.
db2 variations:
None

access
db2
mysql
oracle
postgres
sqlserver