外键约束
文章目录
作为外键一定要和关联的主键的数据类型保持一致
新增部门经理表
+----+------+------+-------------+
| id | name | age | is_marriged |
+----+------+------+-------------+
| 1 | Tim | 29 | 1 |
| 2 | Leo | 35 | 1 |
| 3 | John | 41 | 0 |
+----+------+------+-------------+
新增部门员工表
+----+-------+---------+-----------+
| id | name | regular | managerid |
+----+-------+---------+-----------+
| <