外键约束导致问题,原语句:foreign key (dept_name) references department on delete set null
改为:foreign key (dept_name) references department(dept_name) on delete set null 竟然通过了,
也就是说即使外键名称与原主键名称相同,也要注明,不可省略。
外键约束导致问题,原语句:foreign key (dept_name) references department on delete set null
改为:foreign key (dept_name) references department(dept_name) on delete set null 竟然通过了,
也就是说即使外键名称与原主键名称相同,也要注明,不可省略。