Current revision posted to MySQL Tutorials by admin on 12/19/2008 7:34:58 PM
Delete Data
The DELETE statement deletes rows from a table that satisfy the condition given by the WHERE clause. For example to delete a record from species table where id equals 1
mysql> DELETE FROM species WHERE id = 1;
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM species;
+----+-------+
| id | name |
+----+-------+
| 2 | Bird |
| 3 | Fish |
| 4 | Dog |
+----+-------+
3 rows in set (0.01 sec)
