1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(a int, key (a));
3
INSERT INTO t1 VALUES (1), (2);
5
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
6
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
7
DROP TABLE IF EXISTS `t1`;
11
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
13
ALTER TABLE `t1` DISABLE KEYS;
14
INSERT INTO `t1` VALUES (1),(2);
15
ALTER TABLE `t1` ENABLE KEYS;
17
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
18
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;