1832-cannot change column 'c_id' :used in a foreign key解决方法,已解决

1.字段c_id忘记勾选“不是null”选项,重新勾上,按ctrl+s保存时,报错。

1832-cannot change column 'c_id' :used in a foreign key解决方法,已解决

2.报错原因:存在c_id的外键,不允许修改,于是删除此外键1832-cannot change column 'c_id' :used in a foreign key解决方法,已解决

3.删除外键截图:

1832-cannot change column 'c_id' :used in a foreign key解决方法,已解决

4.ctrl+s保存字段:

1832-cannot change column 'c_id' :used in a foreign key解决方法,已解决

5.重新加上外键:

1832-cannot change column 'c_id' :used in a foreign key解决方法,已解决

6.成功解决。