Usage and examples of the SQL VALUES keyword

SQL Keywords Reference

VALUES

The VALUES command specifies the values for the INSERT INTO statement.

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 inserted 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