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)