SQL Delete Statement with Example
SQL Delete Statement is used to delete one or more records from a table.
- We can delete all records in a table or can delete only particular records in a table using DELETE statement.
Synatx
DELETE FROM table WHERE condition
Deleting All Rows
DELETE FROM table;
Deleting Specific Rows
DELETE FROM table
WHERE conditions;
Example:
Employee Table having below records
Delete Employee record from Employee Table whose first name is ‘Praj’
mysql> Delete from Employee where Employee_FirstName='Praj' ;Query OK, 1 row affected (0.17 sec)
Recommended Articles: