Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Inserting selected rows

Check all conditions

Report a typo

What should you check before you copy data from table1 to table2 with INSERT INTO SELECT statement?

Select one or more options from the list

table2 is empty

Column names in table1 and table2 are the same

Data types are compatible

Column order is correct

___

Create a free account to access the full topic