how to insert data from table to another empty table
for example employe: emp_name ,emp_no
to empployeeTest with the same columns
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek JaiswalPosted Aug 27, 2014, 6:34 AM
try this
INSERT INTO
employeeTest (emp_name , emp_no )
SELECT emp_name , emp_no
FROM employee;