drop table if exists `�s�P`; drop table if exists `�s�Q`; drop table if exists `�s�R`; drop table if exists `�s�S`; drop table if exists `�s�T`; drop table if exists `�s�U`; drop table if exists `�s�V`; drop table if exists `�s�W`; drop table if exists `�s�X`; drop table if exists `�s�P�O`; drop table if exists `�s�P�P`; drop table if exists `�s�P�Q`; SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `�s�Pa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Pb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Qa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Qb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Ra` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Rb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Sa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�Sb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�Ta` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�Tb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�Ua` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�Ub` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�Va` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�Vb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�Wa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�Wb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�Xa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�Xb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�Oa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�Ob` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�Pa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�Pb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�Qa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; CREATE TABLE `�s�P�Qb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; INSERT INTO `�s�Pa` VALUES ('�'),('�'),('�'); INSERT INTO `�s�Pb` VALUES ('�'); INSERT INTO `�s�Qa` VALUES ('��'),('��'),('��'); INSERT INTO `�s�Qb` VALUES ('��'); INSERT INTO `�s�Ra` VALUES ('�\'),('�\'),('�\'); INSERT INTO `�s�Rb` VALUES ('�\'); INSERT INTO `�s�Sa` VALUES ('�'),('�'),('�'); INSERT INTO `�s�Sb` VALUES ('�'); INSERT INTO `�s�Ta` VALUES ('��'),('��'),('��'); INSERT INTO `�s�Tb` VALUES ('��'); INSERT INTO `�s�Ua` VALUES ('�\'),('�\'),('�\'); INSERT INTO `�s�Ub` VALUES ('�\'); INSERT INTO `�s�Va` VALUES ('�'),('�'),('�'); INSERT INTO `�s�Vb` VALUES ('�'); INSERT INTO `�s�Wa` VALUES ('��'),('��'),('��'); INSERT INTO `�s�Wb` VALUES ('��'); INSERT INTO `�s�Xa` VALUES ('�\'),('�\'),('�\'); INSERT INTO `�s�Xb` VALUES ('�\'); INSERT INTO `�s�P�Oa` VALUES ('�'),('�'),('�'); INSERT INTO `�s�P�Ob` VALUES ('�'); INSERT INTO `�s�P�Pa` VALUES ('��'),('��'),('��'); INSERT INTO `�s�P�Pb` VALUES ('��'); INSERT INTO `�s�P�Qa` VALUES ('�\'),('�\'),('�\'); INSERT INTO `�s�P�Qb` VALUES ('�\'); SELECT `�b�P` FROM `�s�Pa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Pb`); �b�P � SELECT `�b�P` FROM `�s�Pa` WHERE EXISTS (SELECT `�b�P` FROM `�s�Pb` WHERE `�s�Pa`.`�b�P` = `�s�Pb`.`�b�P`); �b�P � SELECT `�b�P` FROM `�s�Pa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Pb` WHERE `�s�Pa`.`�b�P` = `�s�Pb`.`�b�P`); �b�P � � SELECT `�b�P` FROM `�s�Qa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Qb`); �b�P �� SELECT `�b�P` FROM `�s�Qa` WHERE EXISTS (SELECT `�b�P` FROM `�s�Qb` WHERE `�s�Qa`.`�b�P` = `�s�Qb`.`�b�P`); �b�P �� SELECT `�b�P` FROM `�s�Qa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Qb` WHERE `�s�Qa`.`�b�P` = `�s�Qb`.`�b�P`); �b�P �� �� SELECT `�b�P` FROM `�s�Ra` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Rb`); �b�P �\ SELECT `�b�P` FROM `�s�Ra` WHERE EXISTS (SELECT `�b�P` FROM `�s�Rb` WHERE `�s�Ra`.`�b�P` = `�s�Rb`.`�b�P`); �b�P �\ SELECT `�b�P` FROM `�s�Ra` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Rb` WHERE `�s�Ra`.`�b�P` = `�s�Rb`.`�b�P`); �b�P �\ �\ SELECT `�b�P` FROM `�s�Sa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Sb`); �b�P � SELECT `�b�P` FROM `�s�Sa` WHERE EXISTS (SELECT `�b�P` FROM `�s�Sb` WHERE `�s�Sa`.`�b�P` = `�s�Sb`.`�b�P`); �b�P � SELECT `�b�P` FROM `�s�Sa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Sb` WHERE `�s�Sa`.`�b�P` = `�s�Sb`.`�b�P`); �b�P � � SELECT `�b�P` FROM `�s�Ta` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Tb`); �b�P �� SELECT `�b�P` FROM `�s�Ta` WHERE EXISTS (SELECT `�b�P` FROM `�s�Tb` WHERE `�s�Ta`.`�b�P` = `�s�Tb`.`�b�P`); �b�P �� SELECT `�b�P` FROM `�s�Ta` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Tb` WHERE `�s�Ta`.`�b�P` = `�s�Tb`.`�b�P`); �b�P �� �� SELECT `�b�P` FROM `�s�Ua` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Ub`); �b�P �\ SELECT `�b�P` FROM `�s�Ua` WHERE EXISTS (SELECT `�b�P` FROM `�s�Ub` WHERE `�s�Ua`.`�b�P` = `�s�Ub`.`�b�P`); �b�P �\ SELECT `�b�P` FROM `�s�Ua` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Ub` WHERE `�s�Ua`.`�b�P` = `�s�Ub`.`�b�P`); �b�P �\ �\ SELECT `�b�P` FROM `�s�Va` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Vb`); �b�P � SELECT `�b�P` FROM `�s�Va` WHERE EXISTS (SELECT `�b�P` FROM `�s�Vb` WHERE `�s�Va`.`�b�P` = `�s�Vb`.`�b�P`); �b�P � SELECT `�b�P` FROM `�s�Va` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Vb` WHERE `�s�Va`.`�b�P` = `�s�Vb`.`�b�P`); �b�P � � SELECT `�b�P` FROM `�s�Wa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Wb`); �b�P �� SELECT `�b�P` FROM `�s�Wa` WHERE EXISTS (SELECT `�b�P` FROM `�s�Wb` WHERE `�s�Wa`.`�b�P` = `�s�Wb`.`�b�P`); �b�P �� SELECT `�b�P` FROM `�s�Wa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Wb` WHERE `�s�Wa`.`�b�P` = `�s�Wb`.`�b�P`); �b�P �� �� SELECT `�b�P` FROM `�s�Xa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�Xb`); �b�P �\ SELECT `�b�P` FROM `�s�Xa` WHERE EXISTS (SELECT `�b�P` FROM `�s�Xb` WHERE `�s�Xa`.`�b�P` = `�s�Xb`.`�b�P`); �b�P �\ SELECT `�b�P` FROM `�s�Xa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�Xb` WHERE `�s�Xa`.`�b�P` = `�s�Xb`.`�b�P`); �b�P �\ �\ SELECT `�b�P` FROM `�s�P�Oa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�P�Ob`); �b�P � SELECT `�b�P` FROM `�s�P�Oa` WHERE EXISTS (SELECT `�b�P` FROM `�s�P�Ob` WHERE `�s�P�Oa`.`�b�P` = `�s�P�Ob`.`�b�P`); �b�P � SELECT `�b�P` FROM `�s�P�Oa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�P�Ob` WHERE `�s�P�Oa`.`�b�P` = `�s�P�Ob`.`�b�P`); �b�P � � SELECT `�b�P` FROM `�s�P�Pa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�P�Pb`); �b�P �� SELECT `�b�P` FROM `�s�P�Pa` WHERE EXISTS (SELECT `�b�P` FROM `�s�P�Pb` WHERE `�s�P�Pa`.`�b�P` = `�s�P�Pb`.`�b�P`); �b�P �� SELECT `�b�P` FROM `�s�P�Pa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�P�Pb` WHERE `�s�P�Pa`.`�b�P` = `�s�P�Pb`.`�b�P`); �b�P �� �� SELECT `�b�P` FROM `�s�P�Qa` WHERE `�b�P` IN (SELECT `�b�P` FROM `�s�P�Qb`); �b�P �\ SELECT `�b�P` FROM `�s�P�Qa` WHERE EXISTS (SELECT `�b�P` FROM `�s�P�Qb` WHERE `�s�P�Qa`.`�b�P` = `�s�P�Qb`.`�b�P`); �b�P �\ SELECT `�b�P` FROM `�s�P�Qa` WHERE NOT EXISTS (SELECT `�b�P` FROM `�s�P�Qb` WHERE `�s�P�Qa`.`�b�P` = `�s�P�Qb`.`�b�P`); �b�P �\ �\ DROP TABLE `�s�Pa`; DROP TABLE `�s�Pb`; DROP TABLE `�s�Qa`; DROP TABLE `�s�Qb`; DROP TABLE `�s�Ra`; DROP TABLE `�s�Rb`; DROP TABLE `�s�Sa`; DROP TABLE `�s�Sb`; DROP TABLE `�s�Ta`; DROP TABLE `�s�Tb`; DROP TABLE `�s�Ua`; DROP TABLE `�s�Ub`; DROP TABLE `�s�Va`; DROP TABLE `�s�Vb`; DROP TABLE `�s�Wa`; DROP TABLE `�s�Wb`; DROP TABLE `�s�Xa`; DROP TABLE `�s�Xb`; DROP TABLE `�s�P�Oa`; DROP TABLE `�s�P�Ob`; DROP TABLE `�s�P�Pa`; DROP TABLE `�s�P�Pb`; DROP TABLE `�s�P�Qa`; DROP TABLE `�s�P�Qb`;