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 = myisam;
23
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
24
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
25
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
26
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
27
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam;
28
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
29
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
30
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
31
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
32
CREATE TABLE `�ԣ�a` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
33
CREATE TABLE `�ԣ�b` (`�ã�` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY;
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
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` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
67
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
70
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
74
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
77
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
80
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
84
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
87
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
90
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
94
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
97
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
100
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
104
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
107
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
110
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
114
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
117
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
120
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
124
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
127
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
130
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
134
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
137
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
140
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
144
SELECT `�ã�` FROM `�ԣ�a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ�b`);
147
SELECT `�ã�` FROM `�ԣ�a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
150
SELECT `�ã�` FROM `�ԣ�a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ�b` WHERE `�ԣ�a`.`�ã�` = `�ԣ�b`.`�ã�`);
154
SELECT `�ã�` FROM `�ԣ���a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ���b`);
157
SELECT `�ã�` FROM `�ԣ���a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
160
SELECT `�ã�` FROM `�ԣ���a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
164
SELECT `�ã�` FROM `�ԣ���a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ���b`);
167
SELECT `�ã�` FROM `�ԣ���a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
170
SELECT `�ã�` FROM `�ԣ���a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
174
SELECT `�ã�` FROM `�ԣ���a` WHERE `�ã�` IN (SELECT `�ã�` FROM `�ԣ���b`);
177
SELECT `�ã�` FROM `�ԣ���a` WHERE EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);
180
SELECT `�ã�` FROM `�ԣ���a` WHERE NOT EXISTS (SELECT `�ã�` FROM `�ԣ���b` WHERE `�ԣ���a`.`�ã�` = `�ԣ���b`.`�ã�`);