Eine Einführung in
SQL
'INSERT..SELECT' copies data from a SELECT into a table.
SQLite
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to SQLite
none
DB2
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to DB2
none
MS Access
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to MS Access
none
PostgreSQL
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to PostgreSQL
none
Oracle
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to Oracle
none
MS SQL Server
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to MS SQL Server
none
MySQL
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to MySQL
none
Sybase
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to Sybase
none
Mimer SQL
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id>100
INSERT INTO t_peep SELECT population, name FROM cia WHERE region='Europe'; SELECT * FROM t_peep
Specific to Mimer SQL
none