跳转到内容

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 ...
华夏公益教科书