You want to copy the rows from one table into another using a query. In our previous post, we saw how to copy the column names from another table with copying the data , and at this moment that table is empty. Now let’s copy the data from the employee table to populate it.
Actors – Empty Table
To copy the data, we can use the INSERT statement followed by a query that selects all the rows that we want.
INSERT INTO Actors (id, name, gender, salary) SELECT id, name, gender, salary FROM employees
If you want, you can also filter data using the WHERE clause but since we want to copy all of the data from the employees table, I did not used it here.