修改外键

Mysql不支持修改外键，只能删了在重建

通过下面语句查询外键名称；

SHOW CREATE TABLE table1;

CREATE TABLE `table1` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`),
  CONSTRAINT `foreign_name` FOREIGN KEY (`ID`) REFERENCES `table2` (`F_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=827 DEFAULT CHARSET=utf8mb4

然后，删除外键再重建

ALTER TABLE table_name DROP FOREIGN KEY `foreign_name`;
ALTER TABLE table_name ADD CONSTRAINT `foreign_name` FOREIGN KEY(`filed_name`) REFERENCES `关联表名` (`关联字段`);