1 drop table if exists `£Ô£±`;
2 drop table if exists `£Ô£²`;
3 drop table if exists `£Ô£³`;
4 drop table if exists `£Ô£´`;
5 drop table if exists `£Ô£µ`;
6 drop table if exists `£Ô£¶`;
7 drop table if exists `£Ô£·`;
8 drop table if exists `£Ô£¸`;
9 drop table if exists `£Ô£¹`;
11 SET character_set_database = ujis;
12 CREATE TABLE `£Ô£±` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
13 CREATE TABLE `£Ô£²` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
14 CREATE TABLE `£Ô£³` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
15 INSERT INTO `£Ô£±` VALUES('Ž±'),('Ž±'),('¤¢'),('¤¢'),('�íÜ'),('�íÜ');
16 INSERT INTO `£Ô£²` VALUES('Ž²'),('Ž²'),('¤¤'),('¤¤'),('�íÝ'),('�íÝ');
17 INSERT INTO `£Ô£³` VALUES('Ž³'),('Ž³'),('¤¦'),('¤¦'),('�íÞ'),('�íÞ');
18 SELECT * FROM `£Ô£±` UNION DISTINCT SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
26 SELECT * FROM `£Ô£±` UNION ALL SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
40 (SELECT * FROM `£Ô£±`) UNION (SELECT * FROM `£Ô£²`) UNION (SELECT '¤¦') ORDER BY `£Ã£±`;
49 (SELECT '¤¦' AS `£Ã£±`) UNION (SELECT * FROM `£Ô£±`) UNION (SELECT * FROM `£Ô£²`) ORDER BY `£Ã£±`;
58 SELECT `£Ã£±`, COUNT(*) FROM `£Ô£±` GROUP BY `£Ã£±` UNION
59 SELECT `£Ã£±`, COUNT(*) FROM `£Ô£²` GROUP BY `£Ã£±` ORDER BY `£Ã£±`;
67 SELECT * FROM `£Ô£±` UNION DISTINCT
68 SELECT * FROM `£Ô£²` UNION ALL
69 SELECT * FROM `£Ô£³` ORDER BY `£Ã£±`;
83 SELECT * FROM `£Ô£±` UNION ALL
84 SELECT * FROM `£Ô£²` UNION DISTINCT
85 SELECT * FROM `£Ô£³` ORDER BY `£Ã£±`;
96 SELECT * FROM `£Ô£±` UNION SELECT REPEAT(`£Ã£±`,5) FROM `£Ô£²` ORDER BY `£Ã£±`;
107 CREATE TABLE `£Ô£±` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MYISAM;
108 CREATE TABLE `£Ô£²` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MYISAM;
109 CREATE TABLE `£Ô£³` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MYISAM;
110 INSERT INTO `£Ô£±` VALUES('Ž±'),('Ž±'),('¤¢'),('¤¢'),('�íÜ'),('�íÜ');
111 INSERT INTO `£Ô£²` VALUES('Ž²'),('Ž²'),('¤¤'),('¤¤'),('�íÝ'),('�íÝ');
112 INSERT INTO `£Ô£³` VALUES('Ž³'),('Ž³'),('¤¦'),('¤¦'),('�íÞ'),('�íÞ');
113 SELECT * FROM `£Ô£±` UNION DISTINCT SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
121 SELECT * FROM `£Ô£±` UNION ALL SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
135 (SELECT * FROM `£Ô£±`) UNION (SELECT * FROM `£Ô£²`) UNION (SELECT '¤¦') ORDER BY `£Ã£±`;
144 (SELECT '¤¦' AS `£Ã£±`) UNION (SELECT * FROM `£Ô£±`) UNION (SELECT * FROM `£Ô£²`) ORDER BY `£Ã£±`;
153 SELECT `£Ã£±`, COUNT(*) FROM `£Ô£±` GROUP BY `£Ã£±` UNION
154 SELECT `£Ã£±`, COUNT(*) FROM `£Ô£²` GROUP BY `£Ã£±` ORDER BY `£Ã£±`;
162 SELECT * FROM `£Ô£±` UNION DISTINCT
163 SELECT * FROM `£Ô£²` UNION ALL
164 SELECT * FROM `£Ô£³` ORDER BY `£Ã£±`;
178 SELECT * FROM `£Ô£±` UNION ALL
179 SELECT * FROM `£Ô£²` UNION DISTINCT
180 SELECT * FROM `£Ô£³` ORDER BY `£Ã£±`;
191 SELECT * FROM `£Ô£±` UNION SELECT REPEAT(`£Ã£±`,5) FROM `£Ô£²` ORDER BY `£Ã£±`;
202 CREATE TABLE `£Ô£±` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
203 CREATE TABLE `£Ô£²` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
204 CREATE TABLE `£Ô£³` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
205 INSERT INTO `£Ô£±` VALUES('Ž±'),('Ž±'),('¤¢'),('¤¢'),('�íÜ'),('�íÜ');
206 INSERT INTO `£Ô£²` VALUES('Ž²'),('Ž²'),('¤¤'),('¤¤'),('�íÝ'),('�íÝ');
207 INSERT INTO `£Ô£³` VALUES('Ž³'),('Ž³'),('¤¦'),('¤¦'),('�íÞ'),('�íÞ');
208 SELECT * FROM `£Ô£±` UNION DISTINCT SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
216 SELECT * FROM `£Ô£±` UNION ALL SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
230 (SELECT * FROM `£Ô£±`) UNION (SELECT * FROM `£Ô£²`) UNION (SELECT '¤¦') ORDER BY `£Ã£±`;
239 (SELECT '¤¦' AS `£Ã£±`) UNION (SELECT * FROM `£Ô£±`) UNION (SELECT * FROM `£Ô£²`) ORDER BY `£Ã£±`;
248 SELECT `£Ã£±`, COUNT(*) FROM `£Ô£±` GROUP BY `£Ã£±` UNION
249 SELECT `£Ã£±`, COUNT(*) FROM `£Ô£²` GROUP BY `£Ã£±` ORDER BY `£Ã£±`;
257 SELECT * FROM `£Ô£±` UNION DISTINCT
258 SELECT * FROM `£Ô£²` UNION ALL
259 SELECT * FROM `£Ô£³` ORDER BY `£Ã£±`;
273 SELECT * FROM `£Ô£±` UNION ALL
274 SELECT * FROM `£Ô£²` UNION DISTINCT
275 SELECT * FROM `£Ô£³` ORDER BY `£Ã£±`;
286 SELECT * FROM `£Ô£±` UNION SELECT REPEAT(`£Ã£±`,5) FROM `£Ô£²` ORDER BY `£Ã£±`;
297 CREATE TABLE `£Ô£±` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = InnoDB;
298 CREATE TABLE `£Ô£²` (`£Ã£±` char(1), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MyISAM;
299 INSERT INTO `£Ô£±` VALUES('Ž±'),('Ž±'),('¤¢'),('¤¢'),('�íÜ'),('�íÜ');
300 INSERT INTO `£Ô£²` VALUES('Ž²'),('Ž²'),('¤¤'),('¤¤'),('�íÝ'),('�íÝ');
301 SELECT * FROM `£Ô£±` UNION DISTINCT SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;
309 SELECT * FROM `£Ô£±` UNION ALL SELECT * FROM `£Ô£²` ORDER BY `£Ã£±`;