SQL INSERT INTO
Insert New
Rows
The INSERT INTO statement
inserts 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,....) |
Insert a New
Row
This "Persons"
table:
| LastName |
FirstName |
Address |
City |
| Pettersen |
Kari |
Storgt 20 |
Stavanger |
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 |
Stavanger |
| Hetland |
Camilla |
Hagabakka 24 |
Sandnes |
Insert Data in
Specified Columns
This "Persons"
table:
| LastName |
FirstName |
Address |
City |
| Pettersen |
Kari |
Storgt 20 |
Stavanger |
| 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 |
Stavanger |
| Hetland |
Camilla |
Hagabakka 24 |
Sandnes |
| Rasmussen |
|
Storgt 67 |
|
Update
Rows
The UPDATE statement
updates or changes rows:
UPDATE table_name SET column_name =
new_value
WHERE column_name =
some_value |
Person:
| LastName |
FirstName |
Address |
City |
| Nilsen |
Fred |
Kirkegt 56 |
Stavanger |
| Rasmussen |
|
Storgt 67 |
|
Update one
Column in a Row
We want to add a first name
to the person with a last name of
"Rasmussen":
UPDATE Person SET FirstName =
'Nina'
WHERE LastName =
'Rasmussen' |
Update
several Columns in a Row
We want to change the
address and add the name of the city:
UPDATE Person
SET Address = 'Stien 12',
City = 'Stavanger'
WHERE LastName =
'Rasmussen' |
Result
| LastName |
FirstName |
Address |
City |
| Nilsen |
Fred |
Kirkegt 56 |
Stavanger |
| Rasmussen |
Nina |
Stien 12 |
Stavanger |
|
|
