Insert values returned from SQL query to another table

Question

The returned structure of an SQL query is: id | label

I've created a table with the same structure, how to insert the returned lines to this new table.

what RDBMS (mySQL, SQL SErver, Oracle?) syntax for the select into varies by DB. — xQbert
– xQbert, Commented Dec 10, 2014 at 21:34

Barmar · Accepted Answer · 2014-12-10 21:34:21Z

2

INSERT INTO new_table (id, label)
<put select query here>

answered Dec 10, 2014 at 21:34

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maksim Khaitovich · Accepted Answer · 2014-12-10 21:36:02Z

0

insert into SecondTable (id, label) select id, label from OriginalTable;

answered Dec 10, 2014 at 21:36

Maksim Khaitovich

4,7928 gold badges43 silver badges73 bronze badges