INSERT INTO

The INSERT INTO command is utilized to add new rows to a table.

The following SQL statement inserts a new record into the “Customers” table:

Example

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

The provided SQL will insert a new record, populating data solely in the “CustomerName”, “City”, and “Country” columns, with “CustomerID” automatically updated:

Example

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