The DELETE statement deletes record, or records, from MySQL table. In order to delete a specific row or rows the WHERE clause is used.
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';