mysql> SELECT * FROM employee;
+----+-----------+------+------+---------+------+-------+
| id | username | age | addr | salary | sex | depId |pId|
+----+-----------+------+------+---------+------+-------+
| 1 | 张三 | 21 | 山东 | 5432.12 | 男 | 1 | 1
| 2 | 李四 | 32 | 河北 | 6432.00 | 男 | 2 | 2
| 3 | 王五 | 26 | 北京 | 5932.92 | 女 | 3 | 3
| 4 | 赵六 | 32 | 上海 | 6232.14 | 男 | 4 | 4
| 5 | 田七 | 19 | 北京 | 4932.92 | 保密 | 1 | 4
| 6 | Mr Adword | 55 | 美国 | 9432.99 | 男 | 4 | 3
| 7 | 田七 | 19 | 北京 | 4932.92 | 保密 | 1 | 3
| 8 | 孙八 | 62 | 上海 | 9932.14 | 男 | 2 | 2
| 9 | Mr lili | 45 | 美国 | 9132.99 | 女 | 1 | 1
+----+-----------+------+------+---------+------+-------+
mysql> SELECT * FROM provinces;
+----+-------+
| id | pName |
+----+-------+
| 4 | 上海 |
| 3 | 北京 |
| 1 | 山东 |
| 2 | 河北 |
| 5 | 美国 |
+----+-------+
-- 多表更新
UPDATE employee AS e JOIN provinces AS p ON e.pId=p.id SET e.addr=p.id;
-- 多表删除
DELETE e FROM employee AS e JOIN provinces AS p ON e.pId=p.id;