Delete Data From Database Using SQL Query

Delete Data From Database Using SQL Query. The following SQL commands show how to delete data from database.

 

SQL DELETE Syntax:

DELETE FROM table_name 
WHERE condition;

Example:

DELETE FROM employees 
WHERE name='Oscar';

 

Delete All Records:

DELETE FROM table_name;

Example:

DELETE FROM employees;