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.


Can't insert data because of incompatable formats.
If the data inserted is of the wrong type the insert may fail. Because the date format may depend on the local settings this may cause confusion. Using a 4 digit year and a three character month works for most systems (in English speaking regions).
db2 variations:
None

access
db2
mysql
oracle
postgres
sqlserver