Usage and examples of SQL INSERT INTO keywords

SQL Keywords Reference

INSERT INTO

The INSERT INTO command is used to insert a new row into a table.

The following SQL inserts a new record into the "Customers" table:

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen')　21, 'Stavanger', ''4006, 'Norway');

The following SQL will insert a new record, but only if the data for "CustomerName" "City" and "Country" columns (Customer ID will be automatically updated):

INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');

SQL Keywords Reference