上QQ阅读APP看书，第一时间看更新
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.
It is recommended to do data modification in a transaction, so that you can easily rollback the changes if you find anything wrong.