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