How to use SQL INSERT INTO SELECT Statement

By FoxLearn 2/19/2024 9:49:46 AM   314
The INSERT INTO SELECT statement in SQL is used to copy data from one table and insert it into another table.

It allows you to select data from one or more tables and insert it into another table in a single SQL statement. It's requires that the data types in source and target tables match

Here's the basic syntax of the INSERT INTO SELECT statement

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM source_table
WHERE condition;

- target_table: The name of the table where you want to insert data.

- (column1, column2, ...): The columns in the target table where you want to insert data.

- source_table: The name of the table from which you want to select data.

- column1, column2, ...: The columns in the source table that you want to select data from.

- WHERE condition: An optional condition that filters the rows to be copied from the source table.

sql server insert into select example

Suppose we have two tables: Customers and Persons.

We want to copy the data of persons from the Persons table into the Customers table.

INSERT INTO Customers (CustomerName, City, Country)
SELECT Name, City, Country FROM Persons;

Run this query will help you copy all data from the persons table into the customers table