SQL DELETE Example
The "Persons" table:| P_Id | LastName | FirstName | Address | City |
|---|
| 1 | Hansen | Ola | Timoteivn 10 | Sandnes | |||||
| 2 | Svendson | Tove | Borgvn 23 | Sandnes | |||||
| 3 | Pettersen | Kari | Storgt 20 | Stavanger | |||||
| 4 | Nilsen | Johan | Bakken 2 | Stavanger | |||||
| 5 | Tjessem | Jakob | Nissestien 67 | Sandnes |
Now we want to delete the person "Tjessem, Jakob" in the "Persons" table.
We use the following SQL statement:
DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'
WHERE LastName='Tjessem' AND FirstName='Jakob'
No comments:
Post a Comment