SQL Dialects Reference/Write queries/Insert results from select query into existing table
From Wikibooks, the open-content textbooks collection
[edit] Insert results from select query into existing table
- DB2, Firebird, MSSQL, MySQL, Oracle, PostgreSQL, SQLite, OpenLink Virtuoso, Linter:
INSERT INTO existing_table SELECT columns FROM table