SQL INSERT INTO and INSERT INTO the SELECT statement

The INSERT INTO statement is used to insert records of information into a table.

Syntax:

The first type, specify the column name and the inserted value

INSERT INTO table_name (column1, column2, column3, ...)

VALUES (value1, value2, valu23, ...);

Second, if all the columns in the table are present, it is not necessary to specify the name of the column in the SQL query.But the order of the values ​​should be the same as the order of the columns in the table.

INSERT INTO table_name

VALUES (value1, value2, value3, ...)

Example:

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway')

The INSERT INTO SELECT statement copies data from one table and adds it to another table.

When operating, make sure that the type of the copied data matches the data type of the table to be inserted.

This operation does not affect other data in the destination table.

Syntax:

Copy all data from one table to another.

INSERT INTO table2

SELECT * FROM table1

WHERE condition;

Copy several columns of data from one table to another:

INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...

FROM table1

WHERE condition;

Example:

INSERT INTO Customers (CustomerName, City, Country)

SELECT SupplierName, City, Country FROM Suppliers;

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

SELECT SupplierName, ContactName, Address, City, PostalCode, Country FROM Suppliers;

Insert the result of a Union into a table:

INSERT INTO Team (name, age)

SELECT customer_name AS name, 21 AS age FROM Customers WHERE customer_id IS NOT NULL

UNION

SELECT customer_name, 31 FROM Orders

ORDER BY name;

Get the customer name from the first table, and a fixed number, and the second table, too, and then combine.Then insert into another table.

Reference:

SQL INSERT INTO SELECT Statement

sql - Insert into with union - StackOverflow