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 `�ԣ�`;
10
drop table if exists `�ԣ���`;
11
drop table if exists `�ԣ���`;
12
drop table if exists `�ԣ���`;
14
SET character_set_database = ucs2;
15
SET collation_connection = ucs2_general_ci;
16
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
17
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
18
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
19
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
20
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
21
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
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 = innodb;
29
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
30
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
31
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
32
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
33
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
34
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
35
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
36
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
37
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
38
CREATE TABLE `�ԣ���a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
39
CREATE TABLE `�ԣ���b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb;
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
INSERT INTO `�ԣ���a` VALUES ('��'),('��'),('��');
59
INSERT INTO `�ԣ���b` VALUES ('��');
60
INSERT INTO `�ԣ���a` VALUES ('��'),('��'),('��');
61
INSERT INTO `�ԣ���b` VALUES ('��');
62
INSERT INTO `�ԣ���a` VALUES ('���'),('���'),('���');
63
INSERT INTO `�ԣ���b` VALUES ('���');
64
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
69
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
74
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
77
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
80
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
85
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
90
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
95
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
100
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
105
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
110
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
115
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
118
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
121
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
126
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
131
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
136
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
141
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
146
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
151
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
156
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
159
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
162
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
167
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
172
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
177
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
182
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
187
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
192
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
197
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
200
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
203
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
208
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
213
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
218
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
223
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
228
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
233
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
238
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
241
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
244
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
249
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
254
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
259
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
264
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
269
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
274
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
279
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
282
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
285
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
290
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
295
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
300
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
305
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
310
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
315
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
320
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
323
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
326
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
331
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
336
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
341
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
346
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
351
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
356
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
361
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
364
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
367
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
372
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
377
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
382
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
387
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
392
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b`;
397
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b`;
402
SELECT * FROM `�ԣ�a` JOIN `�ԣ�b` USING (`�ã�`);
405
SELECT * FROM `�ԣ�a` INNER JOIN `�ԣ�b` USING (`�ã�`);
408
SELECT * FROM `�ԣ�a` CROSS JOIN `�ԣ�b`;
413
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` USING (`�ã�`);
418
SELECT * FROM `�ԣ�a` LEFT JOIN `�ԣ�b` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
423
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` USING (`�ã�`);
428
SELECT * FROM `�ԣ�b` RIGHT JOIN `�ԣ�a` ON (`�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
433
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b`;
438
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b`;
443
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b` USING (`�ã�`);
446
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b` USING (`�ã�`);
449
SELECT * FROM `�ԣ���a` CROSS JOIN `�ԣ���b`;
454
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` USING (`�ã�`);
459
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
464
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` USING (`�ã�`);
469
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
474
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b`;
479
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b`;
484
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b` USING (`�ã�`);
487
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b` USING (`�ã�`);
490
SELECT * FROM `�ԣ���a` CROSS JOIN `�ԣ���b`;
495
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` USING (`�ã�`);
500
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
505
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` USING (`�ã�`);
510
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
515
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b`;
520
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b`;
525
SELECT * FROM `�ԣ���a` JOIN `�ԣ���b` USING (`�ã�`);
528
SELECT * FROM `�ԣ���a` INNER JOIN `�ԣ���b` USING (`�ã�`);
531
SELECT * FROM `�ԣ���a` CROSS JOIN `�ԣ���b`;
536
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` USING (`�ã�`);
541
SELECT * FROM `�ԣ���a` LEFT JOIN `�ԣ���b` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
546
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` USING (`�ã�`);
551
SELECT * FROM `�ԣ���b` RIGHT JOIN `�ԣ���a` ON (`�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);