Records deleting in MySQL (DELETE statement)

The DELETE statement deletes record, or records, from MySQL table. In order to delete a specific row or rows the WHERE clause is used.

Syntax

DELETE FROM table_name WHERE some_column = some_value;

In a more realistic example, the following statement deletes the Development department from the department table:

DELETE FROM department WHERE dname = 'Development';