mysql关闭/启用外键约束

 1、有时为了导入数据方便，需要临时关闭外键约束
mysql>SET FOREIGN_KEY_CHECKS=0;

2、打开外键约束
mysql>SET FOREIGN_KEY_CHECKS=1;

3、查看FOREIGN_KEY_CHECKS变量
mysql>select @@FOREIGN_KEY_CHECKS; 

=-=-=-=-=
Powered by Blogilo

转载于:https://www.cnblogs.com/pandachen/p/4264649.html