Copy data from one table to another table

 

Users Table

Employees Table

We want to copy data from Users tabel to  Employee table for this we use below query:

insert into `employees` (`first_name`, `last_name`,`email`) SELECT `users`.`first_name`,`users`.`last_name`,`users`.`email` from `users`;

After that we can see below output:-

Copy data from Users Table