1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
11 SET character_set_database = utf8;
12 CREATE TABLE `T1` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = innodb;
13 CREATE TABLE `T2` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T3` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T4` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = myisam;
16 CREATE TABLE `T5` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = myisam;
17 CREATE TABLE `T6` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = myisam;
18 CREATE TABLE `T7` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = MEMORY;
19 CREATE TABLE `T8` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = MEMORY;
20 CREATE TABLE `T9` (`C1` char(5)) DEFAULT CHARSET = utf8 engine = MEMORY;
21 INSERT INTO `T1` VALUES ('アイウエオ');
22 INSERT INTO `T2` VALUES ('あいうえお');
23 INSERT INTO `T3` VALUES ('龔龖龗龞龡');
24 INSERT INTO `T4` VALUES ('アイウエオ');
25 INSERT INTO `T5` VALUES ('あいうえお');
26 INSERT INTO `T6` VALUES ('龔龖龗龞龡');
27 INSERT INTO `T7` VALUES ('アイウエオ');
28 INSERT INTO `T8` VALUES ('あいうえお');
29 INSERT INTO `T9` VALUES ('龔龖龗龞龡');
30 SELECT REPLACE(`C1`,'ア','アア') FROM `T1`;
31 REPLACE(`C1`,'ア','アア')
33 SELECT REPLACE(`C1`,'イ','イイ') FROM `T1`;
34 REPLACE(`C1`,'イ','イイ')
36 SELECT REPLACE(`C1`,'ウ','ウウ') FROM `T1`;
37 REPLACE(`C1`,'ウ','ウウ')
39 SELECT REPLACE(`C1`,'エ','エエ') FROM `T1`;
40 REPLACE(`C1`,'エ','エエ')
42 SELECT REPLACE(`C1`,'オ','オオ') FROM `T1`;
43 REPLACE(`C1`,'オ','オオ')
45 SELECT REPLACE(`C1`,'あ','ああ') FROM `T2`;
46 REPLACE(`C1`,'あ','ああ')
48 SELECT REPLACE(`C1`,'い','いい') FROM `T2`;
49 REPLACE(`C1`,'い','いい')
51 SELECT REPLACE(`C1`,'う','うう') FROM `T2`;
52 REPLACE(`C1`,'う','うう')
54 SELECT REPLACE(`C1`,'え','ええ') FROM `T2`;
55 REPLACE(`C1`,'え','ええ')
57 SELECT REPLACE(`C1`,'お','おお') FROM `T2`;
58 REPLACE(`C1`,'お','おお')
60 SELECT REPLACE(`C1`,'龔','龔龔') FROM `T3`;
61 REPLACE(`C1`,'龔','龔龔')
63 SELECT REPLACE(`C1`,'龖','龖龖') FROM `T3`;
64 REPLACE(`C1`,'龖','龖龖')
66 SELECT REPLACE(`C1`,'龗','龗龗') FROM `T3`;
67 REPLACE(`C1`,'龗','龗龗')
69 SELECT REPLACE(`C1`,'龞','龞龞') FROM `T3`;
70 REPLACE(`C1`,'龞','龞龞')
72 SELECT REPLACE(`C1`,'龡','龡龡') FROM `T3`;
73 REPLACE(`C1`,'龡','龡龡')
75 SELECT REPLACE(`C1`,'ア','アア') FROM `T4`;
76 REPLACE(`C1`,'ア','アア')
78 SELECT REPLACE(`C1`,'イ','イイ') FROM `T4`;
79 REPLACE(`C1`,'イ','イイ')
81 SELECT REPLACE(`C1`,'ウ','ウウ') FROM `T4`;
82 REPLACE(`C1`,'ウ','ウウ')
84 SELECT REPLACE(`C1`,'エ','エエ') FROM `T4`;
85 REPLACE(`C1`,'エ','エエ')
87 SELECT REPLACE(`C1`,'オ','オオ') FROM `T4`;
88 REPLACE(`C1`,'オ','オオ')
90 SELECT REPLACE(`C1`,'あ','ああ') FROM `T5`;
91 REPLACE(`C1`,'あ','ああ')
93 SELECT REPLACE(`C1`,'い','いい') FROM `T5`;
94 REPLACE(`C1`,'い','いい')
96 SELECT REPLACE(`C1`,'う','うう') FROM `T5`;
97 REPLACE(`C1`,'う','うう')
99 SELECT REPLACE(`C1`,'え','ええ') FROM `T5`;
100 REPLACE(`C1`,'え','ええ')
102 SELECT REPLACE(`C1`,'お','おお') FROM `T5`;
103 REPLACE(`C1`,'お','おお')
105 SELECT REPLACE(`C1`,'龔','龔龔') FROM `T6`;
106 REPLACE(`C1`,'龔','龔龔')
108 SELECT REPLACE(`C1`,'龖','龖龖') FROM `T6`;
109 REPLACE(`C1`,'龖','龖龖')
111 SELECT REPLACE(`C1`,'龗','龗龗') FROM `T6`;
112 REPLACE(`C1`,'龗','龗龗')
114 SELECT REPLACE(`C1`,'龞','龞龞') FROM `T6`;
115 REPLACE(`C1`,'龞','龞龞')
117 SELECT REPLACE(`C1`,'龡','龡龡') FROM `T6`;
118 REPLACE(`C1`,'龡','龡龡')
120 SELECT REPLACE(`C1`,'ア','アア') FROM `T7`;
121 REPLACE(`C1`,'ア','アア')
123 SELECT REPLACE(`C1`,'イ','イイ') FROM `T7`;
124 REPLACE(`C1`,'イ','イイ')
126 SELECT REPLACE(`C1`,'ウ','ウウ') FROM `T7`;
127 REPLACE(`C1`,'ウ','ウウ')
129 SELECT REPLACE(`C1`,'エ','エエ') FROM `T7`;
130 REPLACE(`C1`,'エ','エエ')
132 SELECT REPLACE(`C1`,'オ','オオ') FROM `T7`;
133 REPLACE(`C1`,'オ','オオ')
135 SELECT REPLACE(`C1`,'あ','ああ') FROM `T8`;
136 REPLACE(`C1`,'あ','ああ')
138 SELECT REPLACE(`C1`,'い','いい') FROM `T8`;
139 REPLACE(`C1`,'い','いい')
141 SELECT REPLACE(`C1`,'う','うう') FROM `T8`;
142 REPLACE(`C1`,'う','うう')
144 SELECT REPLACE(`C1`,'え','ええ') FROM `T8`;
145 REPLACE(`C1`,'え','ええ')
147 SELECT REPLACE(`C1`,'お','おお') FROM `T8`;
148 REPLACE(`C1`,'お','おお')
150 SELECT REPLACE(`C1`,'龔','龔龔') FROM `T9`;
151 REPLACE(`C1`,'龔','龔龔')
153 SELECT REPLACE(`C1`,'龖','龖龖') FROM `T9`;
154 REPLACE(`C1`,'龖','龖龖')
156 SELECT REPLACE(`C1`,'龗','龗龗') FROM `T9`;
157 REPLACE(`C1`,'龗','龗龗')
159 SELECT REPLACE(`C1`,'龞','龞龞') FROM `T9`;
160 REPLACE(`C1`,'龞','龞龞')
162 SELECT REPLACE(`C1`,'龡','龡龡') FROM `T9`;
163 REPLACE(`C1`,'龡','龡龡')