Bugl — Daily coding puzzles and drills

INSERT INTO Keyword

Insert Into

The INSERT INTO

command is used to insert new rows in a table. The following SQL inserts a new record in the "Customers" table:

Example

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):

Example

INSERT INTO Customers (CustomerName, City, Country)

VALUES ('Cardinal', 'Stavanger', 'Norway');

SQL INSERT INTO Keyword

SQL INSERT INTO Keyword

INSERT INTO Keyword

Previous

Next

Insert Into

The INSERT INTO

Example

Example

Previous

Next

SQL INSERT INTO Keyword

SQL INSERT INTO Keyword

INSERT INTO Keyword

Previous

Next

Insert Into

The INSERT INTO

Example

Example

Previous

Next