8
10
drop table if exists `T7`;
9
11
drop table if exists `T8`;
10
12
drop table if exists `T9`;
11
drop table if exists `T10`;
12
drop table if exists `T11`;
13
drop table if exists `T12`;
26
25
CREATE TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27
26
CREATE TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
28
27
CREATE TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
29
CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
30
CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
31
CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = heap;
32
CREATE TABLE `T10` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
33
CREATE TABLE `T11` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
34
CREATE TABLE `T12` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
28
CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
29
CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
30
CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
36
32
INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
37
33
INSERT INTO `T2` VALUES ('あ'),('い'),('う');
42
38
INSERT INTO `T7` VALUES ('ア'),('イ'),('ウ');
43
39
INSERT INTO `T8` VALUES ('あ'),('い'),('う');
44
40
INSERT INTO `T9` VALUES ('龔'),('龖'),('龗');
45
INSERT INTO `T10` VALUES ('ア'),('イ'),('ウ');
46
INSERT INTO `T11` VALUES ('あ'),('い'),('う');
47
INSERT INTO `T12` VALUES ('龔'),('龖'),('龗');
49
42
SELECT * FROM `T1`;
50
43
SELECT * FROM `T2`;
98
82
ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
99
83
ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
100
84
ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
101
ALTER TABLE `T10` ADD `C2` CHAR(1) NOT NULL FIRST;
102
ALTER TABLE `T11` ADD `C2` CHAR(1) NOT NULL FIRST;
103
ALTER TABLE `T12` ADD `C2` CHAR(1) NOT NULL FIRST;
105
86
SHOW CREATE TABLE `T1`;
106
87
SHOW CREATE TABLE `T2`;