UPDATE existing records

UPDATE can change an existing record.

schema:scott

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

INSERT and DELETE Operations

INSERT new records

UPDATE existing records

DELETE records

INSERT ... SELECT

INSERT: Not all fields need to be specified

INSERT a date

Explicitly enter a NULL

INSERT problems: reference

DELETE problems: reference

INSERT problems: incompatible formats

String contains a quote '

Data normalization