drop table if exists `sP`; drop table if exists `sQ`; drop table if exists `sR`; drop table if exists `sS`; drop table if exists `sT`; drop table if exists `sU`; drop table if exists `sV`; drop table if exists `sW`; drop table if exists `sX`; SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `sPa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sPb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sQa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sQb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sRa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sRb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `sSa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sSb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sTa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sTb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sVa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sVb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sWa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sWb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sXa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `sXb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; INSERT INTO `sPa` VALUES (''),(''),(''); INSERT INTO `sPb` VALUES (''); INSERT INTO `sQa` VALUES (''),(''),(''); INSERT INTO `sQb` VALUES (''); INSERT INTO `sRa` VALUES ('\'),('\'),('\'); INSERT INTO `sRb` VALUES ('\'); INSERT INTO `sSa` VALUES (''),(''),(''); INSERT INTO `sSb` VALUES (''); INSERT INTO `sTa` VALUES (''),(''),(''); INSERT INTO `sTb` VALUES (''); INSERT INTO `sUa` VALUES ('\'),('\'),('\'); INSERT INTO `sUb` VALUES ('\'); INSERT INTO `sVa` VALUES (''),(''),(''); INSERT INTO `sVb` VALUES (''); INSERT INTO `sWa` VALUES (''),(''),(''); INSERT INTO `sWb` VALUES (''); INSERT INTO `sXa` VALUES ('\'),('\'),('\'); INSERT INTO `sXb` VALUES ('\'); SELECT `bP` FROM `sPa` WHERE `bP` IN (SELECT `bP` FROM `sPb`); bP SELECT `bP` FROM `sPa` WHERE EXISTS (SELECT `bP` FROM `sPb` WHERE `sPa`.`bP` = `sPb`.`bP`); bP SELECT `bP` FROM `sPa` WHERE NOT EXISTS (SELECT `bP` FROM `sPb` WHERE `sPa`.`bP` = `sPb`.`bP`); bP SELECT `bP` FROM `sQa` WHERE `bP` IN (SELECT `bP` FROM `sQb`); bP SELECT `bP` FROM `sQa` WHERE EXISTS (SELECT `bP` FROM `sQb` WHERE `sQa`.`bP` = `sQb`.`bP`); bP SELECT `bP` FROM `sQa` WHERE NOT EXISTS (SELECT `bP` FROM `sQb` WHERE `sQa`.`bP` = `sQb`.`bP`); bP SELECT `bP` FROM `sRa` WHERE `bP` IN (SELECT `bP` FROM `sRb`); bP \ SELECT `bP` FROM `sRa` WHERE EXISTS (SELECT `bP` FROM `sRb` WHERE `sRa`.`bP` = `sRb`.`bP`); bP \ SELECT `bP` FROM `sRa` WHERE NOT EXISTS (SELECT `bP` FROM `sRb` WHERE `sRa`.`bP` = `sRb`.`bP`); bP \ \ SELECT `bP` FROM `sSa` WHERE `bP` IN (SELECT `bP` FROM `sSb`); bP SELECT `bP` FROM `sSa` WHERE EXISTS (SELECT `bP` FROM `sSb` WHERE `sSa`.`bP` = `sSb`.`bP`); bP SELECT `bP` FROM `sSa` WHERE NOT EXISTS (SELECT `bP` FROM `sSb` WHERE `sSa`.`bP` = `sSb`.`bP`); bP SELECT `bP` FROM `sTa` WHERE `bP` IN (SELECT `bP` FROM `sTb`); bP SELECT `bP` FROM `sTa` WHERE EXISTS (SELECT `bP` FROM `sTb` WHERE `sTa`.`bP` = `sTb`.`bP`); bP SELECT `bP` FROM `sTa` WHERE NOT EXISTS (SELECT `bP` FROM `sTb` WHERE `sTa`.`bP` = `sTb`.`bP`); bP SELECT `bP` FROM `sUa` WHERE `bP` IN (SELECT `bP` FROM `sUb`); bP \ SELECT `bP` FROM `sUa` WHERE EXISTS (SELECT `bP` FROM `sUb` WHERE `sUa`.`bP` = `sUb`.`bP`); bP \ SELECT `bP` FROM `sUa` WHERE NOT EXISTS (SELECT `bP` FROM `sUb` WHERE `sUa`.`bP` = `sUb`.`bP`); bP \ \ SELECT `bP` FROM `sVa` WHERE `bP` IN (SELECT `bP` FROM `sVb`); bP SELECT `bP` FROM `sVa` WHERE EXISTS (SELECT `bP` FROM `sVb` WHERE `sVa`.`bP` = `sVb`.`bP`); bP SELECT `bP` FROM `sVa` WHERE NOT EXISTS (SELECT `bP` FROM `sVb` WHERE `sVa`.`bP` = `sVb`.`bP`); bP SELECT `bP` FROM `sWa` WHERE `bP` IN (SELECT `bP` FROM `sWb`); bP SELECT `bP` FROM `sWa` WHERE EXISTS (SELECT `bP` FROM `sWb` WHERE `sWa`.`bP` = `sWb`.`bP`); bP SELECT `bP` FROM `sWa` WHERE NOT EXISTS (SELECT `bP` FROM `sWb` WHERE `sWa`.`bP` = `sWb`.`bP`); bP SELECT `bP` FROM `sXa` WHERE `bP` IN (SELECT `bP` FROM `sXb`); bP \ SELECT `bP` FROM `sXa` WHERE EXISTS (SELECT `bP` FROM `sXb` WHERE `sXa`.`bP` = `sXb`.`bP`); bP \ SELECT `bP` FROM `sXa` WHERE NOT EXISTS (SELECT `bP` FROM `sXb` WHERE `sXa`.`bP` = `sXb`.`bP`); bP \ \ DROP TABLE `sPa`; DROP TABLE `sPb`; DROP TABLE `sQa`; DROP TABLE `sQb`; DROP TABLE `sRa`; DROP TABLE `sRb`; DROP TABLE `sSa`; DROP TABLE `sSb`; DROP TABLE `sTa`; DROP TABLE `sTb`; DROP TABLE `sUa`; DROP TABLE `sUb`; DROP TABLE `sVa`; DROP TABLE `sVb`; DROP TABLE `sWa`; DROP TABLE `sWb`; DROP TABLE `sXa`; DROP TABLE `sXb`;