思路是:先删除aa表的外键,再删除bb的数据,之后插入数据,重新为aa表添加外键。
–删除外键
ALTER TABLE aa DROP FOREIGN KEY FK_1;
–删除数据
DELETE from bb;
–插入数据
Omcs.sql
–重建外键
ALTER table aa add CONSTRAINT FK_1 FOREIGN key(code_name) REFERENCES bb(code);
ON UPDATE RESTRT
ON DELE
TE RESTRICT;