The INSERT INTO statement is used
to insert new rows into a table.
INSERT INTO table_name VALUES (value1, value2,....) |
You can also specify the columns
for which you want to insert data:
INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) |
This "Persons" table:
LastName |
FirstName |
Address |
City |
Pettersen |
Kari |
Storgt 20 |
|
And this SQL statement:
INSERT INTO Persons VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes') |
Will give this result:
LastName |
FirstName |
Address |
City |
Pettersen |
Kari |
Storgt 20 |
|
Hetland |
Camilla |
Hagabakka 24 |
Sandnes |
This "Persons" table:
LastName |
FirstName |
Address |
City |
Pettersen |
Kari |
Storgt 20 |
|
Hetland |
Camilla |
Hagabakka 24 |
Sandnes |
And This SQL statement:
INSERT INTO Persons (LastName, Address) VALUES ('Rasmussen', 'Storgt 67') |
Will give this result:
LastName |
FirstName |
Address |
City |
Pettersen |
Kari |
Storgt 20 |
|
Hetland |
Camilla |
Hagabakka 24 |
Sandnes |
Rasmussen |
|
Storgt 67 |
|