SQL方言参考
完成条件
问题:将 SELECT 查询的结果插入到现有表中
问题:将给定 SELECT 查询(SELECT 列 FROM 表 ...)的结果插入到具有相同或兼容结构的现有表(existing_table)中(与查询结果的结构兼容)。
Insert results from select query into existing table
Problem: Insert results from a given select query (SELECT columns FROM table ...) into existing table (existing_table) of the same or compatible structure (as query result).
| Standard | 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 ... |
最后修改: 2025年04月11日 星期五 14:30