SQL INSERT INTO Keyword

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP








googletag.cmd.push(function() googletag.display('div-gpt-ad-1422003450156-2'); );



SQL INSERT INTO Keyword


❮ SQL Keywords Reference


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');

Try it Yourself »


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');

Try it Yourself »


❮ SQL Keywords Reference


-