The DELETE statement is used to remove one or more rows from a table when a certain condition is met as follows:
> DELETE FROM employee_trans WHERE emp_id = 104;No rows affected (42.298 seconds)-- Verify the result, deleted> SELECT name FROM employee_trans WHERE emp_id = 104;+------+| name |+------++------+No rows selected (0.33 seconds)