1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(a int, key (a));
3
INSERT INTO t1 VALUES (1), (2);
4
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
5
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
6
DROP TABLE IF EXISTS `t1`;
12
ALTER TABLE `t1` DISABLE KEYS;
13
INSERT INTO `t1` VALUES (1),(2);
14
ALTER TABLE `t1` ENABLE KEYS;
15
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
16
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;