Insert data from table to another empty table

Question

how to insert data from table to another empty table for example employe: emp_name emp_no to empployeeTest with the same columns

Abhishek Jaiswal · Answer

Hey! try this INSERT INTO employeeTest ( emp_name  emp_no ) SELECT emp_name  emp_no FROM employee ;