MySQL INSERT INTO SELECT Statement

MySQL INSERT INTO SELECT Statement

The INSERT INTO ... SELECT statement in MySQL is used to insert data from one table into another table.
This is useful when you want to copy data between tables without manually inserting each row.

 Syntax

• target_table → Table where data will be inserted

• source_table → Table from which data is selected

• WHERE → Optional condition to filter rows

✅ The number of columns in INSERT must match the number of columns in SELECT.

🧠 Example Tables

Students2024

StudentsBackup (Empty table with same columns)

 Example 1: Copy All Students to Backup Table

 Example 2: Copy Students from IT Department Only

 Key Points

1. Combines SELECT and INSERT in a single operation.

2. Useful for copying data between tables or archiving records.

3. Columns in INSERT and SELECT must match in number and data type.

4. Optional WHERE clause allows you to filter data before inserting.