A Gentle Introduction to
SQL
INSERT and DELETE
You may need to "Tidy up" before trying these.
INSERT is used to add records.
DELETE removes records.
'INSERT..SELECT' copies data from a SELECT into a table.
INSERT: Not all fields need be specified.
INSERT is used to add records.
INSERT INTO t_peep VALUES (1, 'andrew'); INSERT INTO t_peep VALUES (2, 'gordon')
oracle
access
mysql
DELETE removes records.
DELETE FROM t_peep WHERE id=1
oracle
access
mysql
'INSERT..SELECT' copies data from a SELECT into a table.
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'
oracle
access
mysql
INSERT: Not all fields need be specified.
INSERT INTO t_peep (id) VALUES (99)
oracle
access
mysql