Easy Tutorial
Sql Having Sql Func Mid Sql Between Sql Drop Sql Wildcards Sql Join Inner Sql Join Full Sql Func Lcase Sql Where Sql Join Sql Func Round Sql Primarykey Sql Func First Sql Func Len Sql Distinct Sql Func Ucase Sql Function Sql Delete Sql Autoincrement Func Curtime Sql Update Sql Isnull Func Date Sub Sql Constraints Sql Intro Sql Dates Sql Select Into Sql Hosting Sql Create Table Sql Func Format Sql View Sql Func Count Sql Index Sql Like Sql Datatypes General Sql Datatypes Func Convert Sql Func Avg Sql Foreignkey Sql Func Sum Sql Join Right Func Curdate Sql Alias Sql Union Func Date Add Sql Groupby Sql Summary Sql In Sql Null Values Sql Syntax Sql Tutorial Sql Insert Into Select Sql And Or Sql Join Left Sql Func Now Func Date Sql Top Index Sql Create Db Sql Unique Sql Check Func Extract Sql Alter Sql Notnull Func Now Sql Select Sql Insert Sql Func Max Sql Exists Sql Func Min Func Date Format Func Datediff Mysql Func Getdate Sql Orderby Func Datediff Sql Func Last Sql Create Index Func Dateadd Sql Quickref Func Datepart
❮ Sql Dates Sql Hosting ❯

SQL SELECT INTO Statement

With SQL, you can copy information from one table to another.

The SELECT INTO statement copies data from one table and then inserts it into a new table.

SQL SELECT INTO Statement

The SELECT INTO statement copies data from one table and then inserts it into a new table.

>

Note:

MySQL databases do not support the SELECT ... INTO statement, but they do support INSERT INTO ... SELECT.

Of course, you can use the following statement to copy both the table structure and data:

CREATE TABLE new_table
AS
SELECT * FROM old_table

SQL SELECT INTO Syntax

We can copy all columns into the new table:

Or we can copy only the desired columns into the new table:

| | Tip: The new table will be created with the column names and types defined in the SELECT statement. You can use the AS clause to apply new names. | | --- | --- |

SQL SELECT INTO Examples

Create a backup copy of Websites:

Copy only some columns into the new table:

Copy only websites from China into the new table:

Copy data from multiple tables into the new table:

Tip: The SELECT INTO statement can be used to create a new empty table by another pattern. Simply add a WHERE clause that causes the query to return no data:

❮ Sql Dates Sql Hosting ❯