问题:将 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 ...
Last modified: Friday, 11 April 2025, 2:30 PM