You work as a Database Administrator for Domain.com. The company uses MySQL as its
database.
You have created a table named Employee in the Sales database. Under unavoidable
circumstances, you have to change the structure of the Employee table. Before changing the
structure, you want to copy the data to a new table. For this, you have created a table named
NewEmp with the same structure. Which of the following statements will you use to copy all the
data from Employee to NewEmp?
A.
INSERT NewEmp SELECT * FROM Employee;
B.
INSERT INTO NewEmp FROM Employee;
C.
INSERT NewEmp FROM Employee;
D.
INSERT INTO NewEmp SELECT * FROM Employee;