Mysql修饰符(三)
---+------+------+
| 1 | Nana | 50 |
| 2 | Hebe | 70 |
+------+------+------+
> select * from addr;
+----+-------+---------+---------+
| id | aname | addr | tel |
+----+-------+---------+---------+
| 1 | Nana | addr... | 6668787 |
| 2 | Hebe | addr... | 8989666 |
+----+-------+---------+---------+
删除score表中Hebe的记录，addr表中Hebe的记录自动删除
> delete from score where name="Hebe";
> select * from score;
+------+------+------+
| id | name | math |
+------+------+------+
| 1 | Nana | 50 |
+------+------+------+
> select * from addr;
+----+-------+---------+---------+
| id | aname | addr | tel |
+----+-------+---------+---------+
| 1 | Nana | addr... | 6668787 |
+----+-------+---------+---------+