Slide 14.6: SQL insert into statement

Slide 14.5: SQL create table statement
Slide 14.7: SQL insert into statement (cont.)
Home

SQL Insert into Statement

The INSERT INTO statement is used to insert new rows into a table. It is possible to write the insert into statement in two forms:

 INSERT INTO table
   VALUES ( value1, value2, .... )

 INSERT INTO table ( col1, col2, col3, ... )
   VALUES ( value1, value2, .... )

The first form does not specify the column names where the data will be inserted, only their values.
The second form specifies both the column names and the values to be inserted.

The following empty table Persons was created by the previous create table statement:

P_Id	LastName	FirstName	Address	City

Insert three persons into the table Persons:

 INSERT INTO  Persons
   VALUES( 1, 'Hansen', 'Ola', 'Timoteivn 10', 'Sandnes' );
 INSERT INTO  Persons
   VALUES( 2, 'Svendson', 'Tove', 'Borgvn 23', 'Sandnes' );
 INSERT INTO  Persons
   VALUES( 3, 'Pettersen', 'Kari', 'Storgt 20', 'Stavanger' );

The table Persons now becomes the following:

P_Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3	Pettersen	Kari	Storgt 20	Stavanger

Demonstration
Below is an SQL test area from W3Schools, which uses the well-known Northwind sample database. The tables here are for read only because of the problem of embedding the scripts. For a fully working example, check this by using Chrome.

Result:

The Database includes:

Tablename	Record
Customers	91
Categories	8
Employees	10
OrderDetails	518
Orders	196
Products	77
Shippers	3
Suppliers	29

W3C WebSQL

WebSQL Browser Support