How To Write Insert Into Select Query In SQL

In this article, we will learn how to write a SQL insert into select query.

To copy data from one table and insert it into another table in SQL, the INSERT INTO SELECT statement is used.

Data types in source and target table should match.
Existing records in the target table are unaffected.

Syntax

INSERT INTO TABLE_NAME2 (column1, column2, ...columnN)
SELECT column1, column2, ...columnN FROM TABLE_NAME1;

Example

The subsequent statement would copy data from Article and insert into Backup_Article:

INSERT INTO Backup_Article (Name, Views)
SELECT Name, Views FROM Article;

Also, check How To Write Select Into Query In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.