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 ... |