While creating a new table ProductOrder_2026, which SQL statement correctly inserts
While creating a new table ProductOrder_2026, which SQL statement correctly inserts
all the records from the ProductOrder_2026 table into ProductOrder?
Show answerHide answer
Correct answer: (B) CREATE TABLE ProductOrder_2026 AS SELECT * FROM ProductOrder;
Explanation
CREATE TABLE new_table AS SELECT * FROM old_table creates the new table and copies all rows of the old one into it. CREATE, UPDATE or INSERT cannot follow AS here.