【MySQL】关闭外键约束检查
插入SQL之前,可以关闭外键约束检查
CREATE DATABASE IF NOT EXISTS exam;
SHOW VARIABLES LIKE 'collation%';
SHOW VARIABLES LIKE 'character%';
USE exam;
SET FOREIGN_KEY_CHECKS = 0;
SET FOREIGN_KEY_CHECKS = 1;
插入SQL之前,可以关闭外键约束检查
CREATE DATABASE IF NOT EXISTS exam;
SHOW VARIABLES LIKE 'collation%';
SHOW VARIABLES LIKE 'character%';
USE exam;
SET FOREIGN_KEY_CHECKS = 0;
SET FOREIGN_KEY_CHECKS = 1;