Insert into values SELECT FROM

Question

I'm attempting to INSERT INTO a table data from another table. Although many database engines allow this, I usually seem to have trouble remembering the exact syntax for the SQL engine of the day (MySQL, Oracle, SQL Server, Informix, and DB2).

Is there a silver-bullet syntax from a SQL standard (for example, SQL-92) that I could use to enter the values without having to worry about the underlying database?

Answer 1

Try:

INSERT INTO tableA ( column_1 )
SELECT  col_1
FROM    tableB  

This is standard ANSI SQL and it should be working on any DBMS