SQL – DELETE
SQL DELETE Query
SQL – DELETE Query is used to delete records(rows) from table.
SQL DELETE Syntax :
DELETE FROM TableName WHERE columnName = someColumnValue;
Suppose We Have Following Data :
Example : We want to delete row where id is ‘9’
Example
DELETE FROM Users WHERE ID = ‘9’;
This Will Delete the row where id is ‘9’ . The Table will look Now :
Advertisements
Add Comment
📖 Read More
- 1. SQL - Like
- 2. SQL In Operator
- 3. SQL Between
- 4. SQL Joins - INNER JOIN
- 5. SQL - LEFT JOIN
- 6. SQL - RIGHT JOIN
- 7. SQL - FULL JOIN
- 8. SQL - UNIQUE Key
- 9. SQL PRIMARY Key
- 10. SQL FOREIGN Key
