SQL
zoo.net
UPDATE can change an existing record.
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
DB2
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to DB2
none
Related links:
INSERT, UPDATE and DELETE
INSERT is used to add records.
UPDATE can change an existing record.
DELETE removes records.
'INSERT..SELECT' copies data from a SELECT into a table.
INSERT: Not all fields need be specified. Default values may be specified in the CREATE TABLE clause - otherwise NULL is used.
Insert a date.
Explicitly enter a NULL.
Can't INSERT because of reference.
Cannot DELETE because of reference.
Can't insert data because of incompatable formats.
String contains a quote '
to select the data from 20 different columns into one changing the values according to one other column consisting the positions of the 20 columns