This page discusses - The DELETE Statement, SQL Tutorial
This page discusses - The DELETE Statement, SQL TutorialThe DELETE statement is used to delete rows from a table. database will update that is why deletion and insertion of data will be done.
DELETE FROM table_name WHERE column_name = some_value |
Person:
LName | FName | Address |
---|---|---|
ram | Raj | delhi-5 |
sonu | Shiv | delhi-5 |
DELETE FROM Person WHERE LName = 'sonu' |
Result
LName | FName | Address |
---|---|---|
ram | Raj | delhi-5 |
DELETE FROM table_name |
Ads