INSERT ... SELECT

From SQLZoo
Jump to navigation Jump to search

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

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
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects