Make a copy of all fields in the employees table and insert them into the
employees_bk table.

SELECT *
INTO employees_bk
FROM employees

Results

employeeID

employeeName

1000

John Smith

1001

Fred White

1002

Jane Scott

1003

Samuel Williams

The SELECT INTO inserted the rows from the employees table into the employees_bk table.

Please help us spread the word by socializing it today!

Did you find something wrong with the information on this page? Please take a moment to report it to us
so that we can continue to improve the quality of the information on this site. Click here to
report an issue with this page.