MySQL 8 Cookbook

Deleting

Deleting a record can be done as follows:

mysql> DELETE FROM customers WHERE id=4 AND first_name='Rajiv';Query OK, 1 row affected (0.03 sec)

The WHERE clause is mandatory. Failing to give it will DELETE all the rows of the table. It is recommended to do data modification in a transaction, so that you can easily rollback the changes if you find anything wrong.