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.