In this section, you will learn use of the delete statement.
In this section, you will learn use of the delete statement.The 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