mysql命令行 导入sql报错:
Enter password:
ERROR 1217 (23000) at line 19: Cannot delete or update a parent row: a foreign key constraint fails
解决办法:
导入sql文件前,取消外键检查:set foreign_key_checks=0;
导入sql文件后,加入外键检查:set foreign_key_checks=1;
mysql命令行 导入sql报错:
Enter password:
ERROR 1217 (23000) at line 19: Cannot delete or update a parent row: a foreign key constraint fails
解决办法:
导入sql文件前,取消外键检查:set foreign_key_checks=0;
导入sql文件后,加入外键检查:set foreign_key_checks=1;