INSERT ... SELECT

'INSERT..SELECT' copies data from a SELECT into a table.

1.

schema:scott

DELETE FROM t_peep WHERE id>100

INSERT INTO t_peep
 SELECT population, name FROM cia
  WHERE region='Europe';
SELECT * FROM t_peep

INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep Submit SQLrestore default

result

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