1 DROP TABLE IF EXISTS `£Ô£±a`;
2 DROP TABLE IF EXISTS `£Ô£±b`;
3 DROP TABLE IF EXISTS `£Ô£²a`;
4 DROP TABLE IF EXISTS `£Ô£²b`;
5 DROP TABLE IF EXISTS `£Ô£³a`;
6 DROP TABLE IF EXISTS `£Ô£³b`;
7 DROP TABLE IF EXISTS `£Ô£´a`;
8 DROP TABLE IF EXISTS `£Ô£´b`;
9 DROP TABLE IF EXISTS `£Ô£µa`;
10 DROP TABLE IF EXISTS `£Ô£µb`;
11 DROP TABLE IF EXISTS `£Ô£¶a`;
12 DROP TABLE IF EXISTS `£Ô£¶b`;
13 DROP TABLE IF EXISTS `£Ô£·a`;
14 DROP TABLE IF EXISTS `£Ô£·b`;
15 DROP TABLE IF EXISTS `£Ô£¸a`;
16 DROP TABLE IF EXISTS `£Ô£¸b`;
17 DROP TABLE IF EXISTS `£Ô£¹a`;
18 DROP TABLE IF EXISTS `£Ô£¹b`;
20 SET character_set_database = ucs2;
21 SET collation_connection = ucs2_general_ci;
22 CREATE TABLE `£Ô£±a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
23 CREATE TABLE `£Ô£±b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
24 CREATE TABLE `£Ô£²a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
25 CREATE TABLE `£Ô£²b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
26 CREATE TABLE `£Ô£³a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
27 CREATE TABLE `£Ô£³b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
28 CREATE TABLE `£Ô£´a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MyISAM;
29 CREATE TABLE `£Ô£´b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MyISAM;
30 CREATE TABLE `£Ô£µa` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MyISAM;
31 CREATE TABLE `£Ô£µb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MyISAM;
32 CREATE TABLE `£Ô£¶a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MyISAM;
33 CREATE TABLE `£Ô£¶b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MyISAM;
34 CREATE TABLE `£Ô£·a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
35 CREATE TABLE `£Ô£·b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
36 CREATE TABLE `£Ô£¸a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
37 CREATE TABLE `£Ô£¸b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
38 CREATE TABLE `£Ô£¹a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
39 CREATE TABLE `£Ô£¹b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
40 INSERT INTO `£Ô£±a` VALUES ('Ž±'),('Ž¶'),('Ž»');
41 INSERT INTO `£Ô£±b` VALUES ('Ž±');
42 INSERT INTO `£Ô£²a` VALUES ('¤¢'),('¤«'),('¤µ');
43 INSERT INTO `£Ô£²b` VALUES ('¤¢');
44 INSERT INTO `£Ô£³a` VALUES ('�íÜ'),('�íÝ'),('�íÞ');
45 INSERT INTO `£Ô£³b` VALUES ('�íÜ');
46 INSERT INTO `£Ô£´a` VALUES ('Ž±'),('Ž¶'),('Ž»');
47 INSERT INTO `£Ô£´b` VALUES ('Ž±');
48 INSERT INTO `£Ô£µa` VALUES ('¤¢'),('¤«'),('¤µ');
49 INSERT INTO `£Ô£µb` VALUES ('¤¢');
50 INSERT INTO `£Ô£¶a` VALUES ('�íÜ'),('�íÝ'),('�íÞ');
51 INSERT INTO `£Ô£¶b` VALUES ('�íÜ');
52 INSERT INTO `£Ô£·a` VALUES ('Ž±'),('Ž¶'),('Ž»');
53 INSERT INTO `£Ô£·b` VALUES ('Ž±');
54 INSERT INTO `£Ô£¸a` VALUES ('¤¢'),('¤«'),('¤µ');
55 INSERT INTO `£Ô£¸b` VALUES ('¤¢');
56 INSERT INTO `£Ô£¹a` VALUES ('�íÜ'),('�íÝ'),('�íÞ');
57 INSERT INTO `£Ô£¹b` VALUES ('�íÜ');
58 SELECT * FROM `£Ô£±a` JOIN `£Ô£±b`;
63 SELECT * FROM `£Ô£±a` INNER JOIN `£Ô£±b`;
68 SELECT * FROM `£Ô£±a` JOIN `£Ô£±b` USING (`£Ã£±`);
71 SELECT * FROM `£Ô£±a` INNER JOIN `£Ô£±b` USING (`£Ã£±`);
74 SELECT * FROM `£Ô£±a` CROSS JOIN `£Ô£±b`;
79 SELECT * FROM `£Ô£±a` LEFT JOIN `£Ô£±b` USING (`£Ã£±`);
84 SELECT * FROM `£Ô£±a` LEFT JOIN `£Ô£±b` ON (`£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
89 SELECT * FROM `£Ô£±b` RIGHT JOIN `£Ô£±a` USING (`£Ã£±`);
94 SELECT * FROM `£Ô£±b` RIGHT JOIN `£Ô£±a` ON (`£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
99 SELECT * FROM `£Ô£²a` JOIN `£Ô£²b`;
104 SELECT * FROM `£Ô£²a` INNER JOIN `£Ô£²b`;
109 SELECT * FROM `£Ô£²a` JOIN `£Ô£²b` USING (`£Ã£±`);
112 SELECT * FROM `£Ô£²a` INNER JOIN `£Ô£²b` USING (`£Ã£±`);
115 SELECT * FROM `£Ô£²a` CROSS JOIN `£Ô£²b`;
120 SELECT * FROM `£Ô£²a` LEFT JOIN `£Ô£²b` USING (`£Ã£±`);
125 SELECT * FROM `£Ô£²a` LEFT JOIN `£Ô£²b` ON (`£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
130 SELECT * FROM `£Ô£²b` RIGHT JOIN `£Ô£²a` USING (`£Ã£±`);
135 SELECT * FROM `£Ô£²b` RIGHT JOIN `£Ô£²a` ON (`£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
140 SELECT * FROM `£Ô£³a` JOIN `£Ô£³b`;
145 SELECT * FROM `£Ô£³a` INNER JOIN `£Ô£³b`;
150 SELECT * FROM `£Ô£³a` JOIN `£Ô£³b` USING (`£Ã£±`);
153 SELECT * FROM `£Ô£³a` INNER JOIN `£Ô£³b` USING (`£Ã£±`);
156 SELECT * FROM `£Ô£³a` CROSS JOIN `£Ô£³b`;
161 SELECT * FROM `£Ô£³a` LEFT JOIN `£Ô£³b` USING (`£Ã£±`);
166 SELECT * FROM `£Ô£³a` LEFT JOIN `£Ô£³b` ON (`£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
171 SELECT * FROM `£Ô£³b` RIGHT JOIN `£Ô£³a` USING (`£Ã£±`);
176 SELECT * FROM `£Ô£³b` RIGHT JOIN `£Ô£³a` ON (`£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
181 SELECT * FROM `£Ô£´a` JOIN `£Ô£´b`;
186 SELECT * FROM `£Ô£´a` INNER JOIN `£Ô£´b`;
191 SELECT * FROM `£Ô£´a` JOIN `£Ô£´b` USING (`£Ã£±`);
194 SELECT * FROM `£Ô£´a` INNER JOIN `£Ô£´b` USING (`£Ã£±`);
197 SELECT * FROM `£Ô£´a` CROSS JOIN `£Ô£´b`;
202 SELECT * FROM `£Ô£´a` LEFT JOIN `£Ô£´b` USING (`£Ã£±`);
207 SELECT * FROM `£Ô£´a` LEFT JOIN `£Ô£´b` ON (`£Ô£´a`.`£Ã£±` = `£Ô£´b`.`£Ã£±`);
212 SELECT * FROM `£Ô£´b` RIGHT JOIN `£Ô£´a` USING (`£Ã£±`);
217 SELECT * FROM `£Ô£´b` RIGHT JOIN `£Ô£´a` ON (`£Ô£´a`.`£Ã£±` = `£Ô£´b`.`£Ã£±`);
222 SELECT * FROM `£Ô£µa` JOIN `£Ô£µb`;
227 SELECT * FROM `£Ô£µa` INNER JOIN `£Ô£µb`;
232 SELECT * FROM `£Ô£µa` JOIN `£Ô£µb` USING (`£Ã£±`);
235 SELECT * FROM `£Ô£µa` INNER JOIN `£Ô£µb` USING (`£Ã£±`);
238 SELECT * FROM `£Ô£µa` CROSS JOIN `£Ô£µb`;
243 SELECT * FROM `£Ô£µa` LEFT JOIN `£Ô£µb` USING (`£Ã£±`);
248 SELECT * FROM `£Ô£µa` LEFT JOIN `£Ô£µb` ON (`£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
253 SELECT * FROM `£Ô£µb` RIGHT JOIN `£Ô£µa` USING (`£Ã£±`);
258 SELECT * FROM `£Ô£µb` RIGHT JOIN `£Ô£µa` ON (`£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
263 SELECT * FROM `£Ô£¶a` JOIN `£Ô£¶b`;
268 SELECT * FROM `£Ô£¶a` INNER JOIN `£Ô£¶b`;
273 SELECT * FROM `£Ô£¶a` JOIN `£Ô£¶b` USING (`£Ã£±`);
276 SELECT * FROM `£Ô£¶a` INNER JOIN `£Ô£¶b` USING (`£Ã£±`);
279 SELECT * FROM `£Ô£¶a` CROSS JOIN `£Ô£¶b`;
284 SELECT * FROM `£Ô£¶a` LEFT JOIN `£Ô£¶b` USING (`£Ã£±`);
289 SELECT * FROM `£Ô£¶a` LEFT JOIN `£Ô£¶b` ON (`£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
294 SELECT * FROM `£Ô£¶b` RIGHT JOIN `£Ô£¶a` USING (`£Ã£±`);
299 SELECT * FROM `£Ô£¶b` RIGHT JOIN `£Ô£¶a` ON (`£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
304 SELECT * FROM `£Ô£·a` JOIN `£Ô£·b`;
309 SELECT * FROM `£Ô£·a` INNER JOIN `£Ô£·b`;
314 SELECT * FROM `£Ô£·a` JOIN `£Ô£·b` USING (`£Ã£±`);
317 SELECT * FROM `£Ô£·a` INNER JOIN `£Ô£·b` USING (`£Ã£±`);
320 SELECT * FROM `£Ô£·a` CROSS JOIN `£Ô£·b`;
325 SELECT * FROM `£Ô£·a` LEFT JOIN `£Ô£·b` USING (`£Ã£±`);
330 SELECT * FROM `£Ô£·a` LEFT JOIN `£Ô£·b` ON (`£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
335 SELECT * FROM `£Ô£·b` RIGHT JOIN `£Ô£·a` USING (`£Ã£±`);
340 SELECT * FROM `£Ô£·b` RIGHT JOIN `£Ô£·a` ON (`£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
345 SELECT * FROM `£Ô£¸a` JOIN `£Ô£¸b`;
350 SELECT * FROM `£Ô£¸a` INNER JOIN `£Ô£¸b`;
355 SELECT * FROM `£Ô£¸a` JOIN `£Ô£¸b` USING (`£Ã£±`);
358 SELECT * FROM `£Ô£¸a` INNER JOIN `£Ô£¸b` USING (`£Ã£±`);
361 SELECT * FROM `£Ô£¸a` CROSS JOIN `£Ô£¸b`;
366 SELECT * FROM `£Ô£¸a` LEFT JOIN `£Ô£¸b` USING (`£Ã£±`);
371 SELECT * FROM `£Ô£¸a` LEFT JOIN `£Ô£¸b` ON (`£Ô£¸a`.`£Ã£±` = `£Ô£¸b`.`£Ã£±`);
376 SELECT * FROM `£Ô£¸b` RIGHT JOIN `£Ô£¸a` USING (`£Ã£±`);
381 SELECT * FROM `£Ô£¸b` RIGHT JOIN `£Ô£¸a` ON (`£Ô£¸a`.`£Ã£±` = `£Ô£¸b`.`£Ã£±`);
386 SELECT * FROM `£Ô£¹a` JOIN `£Ô£¹b`;
391 SELECT * FROM `£Ô£¹a` INNER JOIN `£Ô£¹b`;
396 SELECT * FROM `£Ô£¹a` JOIN `£Ô£¹b` USING (`£Ã£±`);
399 SELECT * FROM `£Ô£¹a` INNER JOIN `£Ô£¹b` USING (`£Ã£±`);
402 SELECT * FROM `£Ô£¹a` CROSS JOIN `£Ô£¹b`;
407 SELECT * FROM `£Ô£¹a` LEFT JOIN `£Ô£¹b` USING (`£Ã£±`);
412 SELECT * FROM `£Ô£¹a` LEFT JOIN `£Ô£¹b` ON (`£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
417 SELECT * FROM `£Ô£¹b` RIGHT JOIN `£Ô£¹a` USING (`£Ã£±`);
422 SELECT * FROM `£Ô£¹b` RIGHT JOIN `£Ô£¹a` ON (`£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);