SQL 方言参考/编写查询/将选择查询结果插入现有表
外观
< SQL 方言参考
问题:将给定选择查询(SELECT columns FROM table ...)的结果插入到结构相同或兼容的现有表(existing_table)中。
标准 | INSERT INTO existing_table SELECT columns FROM table ... |
---|---|
DB2 | INSERT INTO existing_table SELECT columns FROM table ... |
Firebird | INSERT INTO existing_table SELECT columns FROM table ... |
Ingres | ? |
Linter | INSERT INTO existing_table SELECT columns FROM table ... |
MonetDB | INSERT INTO existing_table SELECT columns FROM table ... |
MSSQL | INSERT INTO existing_table SELECT columns FROM table ... |
MySQL | INSERT INTO existing_table SELECT columns FROM table ... |
Oracle | INSERT INTO existing_table SELECT columns FROM table ... |
PostgreSQL | INSERT INTO existing_table SELECT columns FROM table ... |
SQLite | INSERT INTO existing_table SELECT columns FROM table ... |
Virtuoso | INSERT INTO existing_table SELECT columns FROM table ... |