Loading lesson path
Concept visual
Start at both ends
❮ SQL Keywords
command specifies the values of an INSERT INTO statement.
The following SQL inserts a new record in 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 insert data in the "CustomerName",
"City", and "Country" columns (CustomerID will be updated automatically):INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');❮ SQL Keywords