14.从表中删除数据

mysql> select * from test;
+----+------+-----------+-------------+
| id | age | name | shouji |
+----+------+-----------+-------------+
| 1 | NULL | oldgirl | NULL |
| 2 | NULL | 老男孩 | NULL |
| 3 | NULL | etiantian | NULL |
| 4 | 24 | zhangxuan | 13511111111 |
| 5 | 22 | huangyan | 13655555555 |
+----+------+-----------+-------------+
5 rows in set (0.00 sec)
mysql> delete from test where id=5;
Query OK, 1 row affected (0.04 sec)
mysql> select * from test;
+----+------+-----------+-------------+
| id | age | name | shouji |
+----+------+-----------+-------------+
| 1 | NULL | oldgirl | NULL |
| 2 | NULL | 老男孩 | NULL |
| 3 | NULL | etiantian | NULL |
| 4 | 24 | zhangxuan | 13511111111 |
+----+------+-----------+-------------+
4 rows in set (0.00 sec)​