MySQL 禁用恢复外键约束

数据计算 数据库
1

可以使用下面的代码：[code]-- ----------------------------------------------------------------------
– SQL data bulk transfer script generated by the MySQL Migration Toolkit

– Disable foreign key checks
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
– Re-enable foreign key checks
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
– End of script[/code]