Alex Alex - 2 months ago 10
SQL Question

Inserting multiple rows in SQL

How do I restore my data from a backup table

table1_bu
into a new table
new_table1
, which has the same structure? I need to insert all the rows from
table1_bu
into
new_table1
.

Answer
INSERT INTO new_table1(Id, Field1)
      SELECT Id, Field1
        FROM table1_bu