Ghilas BELHADJ
Reputation: 14096
Insert values returned from SQL query to another table
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.
Upvotes: 0
Views: 49
Answers (2)
Maksim Khaitovich
Reputation: 4792
insert into SecondTable (id, label) select id, label from OriginalTable;
Upvotes: 0
Related Questions
- How to get values from another table and insert the result into another query
- Insert data into table with result from another select query
- How to insert values from other table?
- Insert results of a query on one table into another table
- Sql insert data from one table to another
- insert data from one mysql table to another
- INSERT values from one table to another using SQL Query
- Insert data into table with result from another select query for one column
- inserting values to table from select statement
- Insert values from one table to another by query