411 REFERENCE · Wikibooks
SQL Dialects Reference/Write queries/Insert results from select query into existing table
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
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).
INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... insert-select.html INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... sql-insert.html INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ... INSERT INTO existing_table SELECT columns FROM table ...