INSERT with SELECT in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the INSERT with SELECT statement do in SQL?

It copies data from one table and inserts it into another table using a SELECT query inside the INSERT statement.

beginner

Write the basic syntax of INSERT with SELECT.

INSERT INTO target_table (column1, column2) SELECT column1, column2 FROM source_table WHERE condition;

beginner

Can you use INSERT with SELECT to insert multiple rows at once?

Yes, the SELECT can return many rows, and all will be inserted into the target table in one statement.

intermediate

What must match between the INSERT columns and the SELECT columns?

The number and order of columns in the INSERT clause must match the columns selected in the SELECT clause.

intermediate

Why might you use INSERT with SELECT instead of multiple INSERT statements?

It is faster and simpler to copy many rows at once from one table to another without writing many separate INSERT commands.

What does the INSERT with SELECT statement do?

A Deletes data from a table

B Creates a new table

C Updates data in a table

D Copies data from one table to another using a SELECT query

The INSERT with SELECT copies data from one table and inserts it into another.

Which must be true for the columns in INSERT with SELECT?

A The SELECT can have more columns than INSERT

B The number and order of columns must match

C The columns can be in any order

D The INSERT can have more columns than SELECT

The number and order of columns in the INSERT and SELECT must match exactly.

Can INSERT with SELECT insert multiple rows at once?

A Only if the table is empty

B No, it inserts only one row

C Yes, it inserts all rows returned by SELECT

D Only if you use a loop

The SELECT can return many rows, and all will be inserted in one statement.

Which SQL keyword is used inside INSERT with SELECT to get data?

A SELECT

B UPDATE

C DELETE

D CREATE

The SELECT keyword is used to choose data to insert.

Why use INSERT with SELECT instead of many single INSERTs?

A It is faster and simpler for many rows

B It deletes old data automatically

C It creates indexes

D It changes table structure

Using INSERT with SELECT copies many rows at once, making it faster and easier.

Explain how the INSERT with SELECT statement works and when you might use it.

Think about copying data between tables without typing many INSERT commands.

Describe the rules for matching columns in INSERT with SELECT.

Imagine matching puzzle pieces for columns.