1
1
drop table if exists t1, t2, t3, t4, t5, t6;
2
2
create table t1 (id int, name varchar(32));
3
3
create table t2 (id int, name varchar(32)) ENGINE="ARCHIVE";
4
create temporary table t3 (id int, name varchar(32)) ENGINE="MEMORY";
5
create temporary table t4 (id int, name varchar(32)) ENGINE="HEAP";
4
create table t3 (id int, name varchar(32)) ENGINE="MEMORY";
5
create table t4 (id int, name varchar(32)) ENGINE="HEAP";
6
6
create table t6 (id int, name varchar(32)) ENGINE="InnoDB";
7
7
insert into t1 values (1, 'first value');
8
8
insert into t1 values (2, 'first value');
70
70
CREATE DATABASE IF NOT EXISTS `test`;
73
DROP TABLE IF EXISTS `t1`;
75
`id` int DEFAULT NULL,
76
`name` varchar(32) DEFAULT NULL
79
ALTER TABLE `t1` DISABLE KEYS;
80
INSERT IGNORE INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
81
ALTER TABLE `t1` ENABLE KEYS;
73
82
DROP TABLE IF EXISTS `t2`;
74
83
CREATE TABLE `t2` (
75
84
`id` int DEFAULT NULL,
79
88
ALTER TABLE `t2` DISABLE KEYS;
80
89
INSERT DELAYED IGNORE INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
81
90
ALTER TABLE `t2` ENABLE KEYS;
82
DROP TABLE IF EXISTS `t1`;
84
`id` int DEFAULT NULL,
85
`name` varchar(32) DEFAULT NULL
88
ALTER TABLE `t1` DISABLE KEYS;
89
INSERT IGNORE INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
90
ALTER TABLE `t1` ENABLE KEYS;
91
DROP TABLE IF EXISTS `t3`;
93
`id` int DEFAULT NULL,
94
`name` varchar(32) DEFAULT NULL
97
ALTER TABLE `t3` DISABLE KEYS;
98
INSERT DELAYED IGNORE INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
99
ALTER TABLE `t3` ENABLE KEYS;
100
DROP TABLE IF EXISTS `t4`;
102
`id` int DEFAULT NULL,
103
`name` varchar(32) DEFAULT NULL
106
ALTER TABLE `t4` DISABLE KEYS;
107
INSERT DELAYED IGNORE INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
108
ALTER TABLE `t4` ENABLE KEYS;
91
109
DROP TABLE IF EXISTS `t6`;
92
110
CREATE TABLE `t6` (
93
111
`id` int DEFAULT NULL,
105
123
CREATE DATABASE IF NOT EXISTS `test`;
126
DROP TABLE IF EXISTS `t1`;
128
`id` int DEFAULT NULL,
129
`name` varchar(32) DEFAULT NULL
132
ALTER TABLE `t1` DISABLE KEYS;
133
INSERT INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
134
ALTER TABLE `t1` ENABLE KEYS;
108
135
DROP TABLE IF EXISTS `t2`;
109
136
CREATE TABLE `t2` (
110
137
`id` int DEFAULT NULL,
114
141
ALTER TABLE `t2` DISABLE KEYS;
115
142
INSERT DELAYED INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
116
143
ALTER TABLE `t2` ENABLE KEYS;
117
DROP TABLE IF EXISTS `t1`;
119
`id` int DEFAULT NULL,
120
`name` varchar(32) DEFAULT NULL
123
ALTER TABLE `t1` DISABLE KEYS;
124
INSERT INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
125
ALTER TABLE `t1` ENABLE KEYS;
144
DROP TABLE IF EXISTS `t3`;
146
`id` int DEFAULT NULL,
147
`name` varchar(32) DEFAULT NULL
150
ALTER TABLE `t3` DISABLE KEYS;
151
INSERT DELAYED INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
152
ALTER TABLE `t3` ENABLE KEYS;
153
DROP TABLE IF EXISTS `t4`;
155
`id` int DEFAULT NULL,
156
`name` varchar(32) DEFAULT NULL
159
ALTER TABLE `t4` DISABLE KEYS;
160
INSERT DELAYED INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
161
ALTER TABLE `t4` ENABLE KEYS;
126
162
DROP TABLE IF EXISTS `t6`;
127
163
CREATE TABLE `t6` (
128
164
`id` int DEFAULT NULL,