Page 118 - SQL

Chapter 34: INSERT

Syntax

• INSERT INTO table_name (column1,column2,column3,...) VALUES
(value1,value2,value3,...);
• INSERT INTO table_name (column1, column2...) SELECT value1, value2... from other_table

Examples

Insert New Row

INSERT INTO Customers
VALUES ('Zack', 'Smith', 'zack@example.com', '7049989942', 'EMAIL');

This statement will insert a new row into the Customers table. Note that a value was not specified
for the Id column, as it will be added automatically. However, all other column values must be
specified.

Insert Only Specified Columns

INSERT INTO Customers (FName, LName, Email, PreferredContact)
VALUES ('Zack', 'Smith', 'zack@example.com', 'EMAIL');

This statement will insert a new row into the Customers table. Data will only be inserted into the
columns specified - note that no value was provided for the PhoneNumber column. Note, however,
that all columns marked as not null must be included.

INSERT data from another table using SELECT

INSERT INTO Customers (FName, LName, PhoneNumber)
SELECT FName, LName, PhoneNumber FROM Employees

This example will insert all Employees into the Customers table. Since the two tables have
different fields and you don't want to move all the fields over, you need to set which fields to insert
into and which fields to select. The correlating field names don't need to be called the same thing,
but then need to be the same data type. This example is assuming that the Id field has an Identity
Specification set and will auto increment.

If you have two tables that have exactly the same field names and just want to move all the
records over you can use:

INSERT INTO Table1
SELECT * FROM Table2

https://riptutorial.com/ 100