menu

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 :

tableFull

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 :

SQL Delete onrowDeleted

Advertisements