How To Write Select Into Query In SQL

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

To copy data from one table into a new table in SQL, the SELECT INTO statement is used.

Using SELECT INTO statement the new table will be created with the column-names and types as defined in the old table. We can create new column names using the AS clause (Aliases).

Syntax

SELECT column_name(s)
INTO NEW_TABLE [IN EXTERNAL_DB]
FROM OLD_TABLE;

Example-1

The subsequent statement would create a backup copy of Articles:

SELECT * INTO Backup_Article
FROM Article;

Example-2

The subsequent statement would use the IN clause to copy the table into a new table in another database:

SELECT * INTO Backup_Article IN 'Backup.mdb'
FROM Article;

Also, check How To Use ANY, ALL Operators 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.