diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_join_ucs2.result')
| -rwxr-xr-x | mysql-test/suite/jp/r/jp_join_ucs2.result | 579 |
1 files changed, 579 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_join_ucs2.result b/mysql-test/suite/jp/r/jp_join_ucs2.result new file mode 100755 index 00000000000..76988f15cc4 --- /dev/null +++ b/mysql-test/suite/jp/r/jp_join_ucs2.result @@ -0,0 +1,579 @@ +drop table if exists `｣ﾔ｣ｱ`; +drop table if exists `｣ﾔ｣ｲ`; +drop table if exists `｣ﾔ｣ｳ`; +drop table if exists `｣ﾔ｣ｴ`; +drop table if exists `｣ﾔ｣ｵ`; +drop table if exists `｣ﾔ｣ｶ`; +drop table if exists `｣ﾔ｣ｷ`; +drop table if exists `｣ﾔ｣ｸ`; +drop table if exists `｣ﾔ｣ｹ`; +drop table if exists `｣ﾔ｣ｱ｣ｰ`; +drop table if exists `｣ﾔ｣ｱ｣ｱ`; +drop table if exists `｣ﾔ｣ｱ｣ｲ`; +SET NAMES ujis; +SET character_set_database = ucs2; +SET collation_connection = ucs2_general_ci; +CREATE TABLE `｣ﾔ｣ｱa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｲa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｲb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｳa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｳb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｴa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｴb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｵa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｵb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｶa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｶb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｷa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｷb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｸa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｸb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｹa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｹb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱ｣ｰa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱ｣ｰb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱ｣ｱa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱ｣ｱb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱ｣ｲa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `｣ﾔ｣ｱ｣ｲb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +INSERT INTO `｣ﾔ｣ｱa` VALUES ('竺'),('叱'),('悉'); +INSERT INTO `｣ﾔ｣ｱb` VALUES ('竺'); +INSERT INTO `｣ﾔ｣ｲa` VALUES ('､｢'),('､ｫ'),('､ｵ'); +INSERT INTO `｣ﾔ｣ｲb` VALUES ('､｢'); +INSERT INTO `｣ﾔ｣ｳa` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ'); +INSERT INTO `｣ﾔ｣ｳb` VALUES ('常ﾜ'); +INSERT INTO `｣ﾔ｣ｴa` VALUES ('竺'),('叱'),('悉'); +INSERT INTO `｣ﾔ｣ｴb` VALUES ('竺'); +INSERT INTO `｣ﾔ｣ｵa` VALUES ('､｢'),('､ｫ'),('､ｵ'); +INSERT INTO `｣ﾔ｣ｵb` VALUES ('､｢'); +INSERT INTO `｣ﾔ｣ｶa` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ'); +INSERT INTO `｣ﾔ｣ｶb` VALUES ('常ﾜ'); +INSERT INTO `｣ﾔ｣ｷa` VALUES ('竺'),('叱'),('悉'); +INSERT INTO `｣ﾔ｣ｷb` VALUES ('竺'); +INSERT INTO `｣ﾔ｣ｸa` VALUES ('､｢'),('､ｫ'),('､ｵ'); +INSERT INTO `｣ﾔ｣ｸb` VALUES ('､｢'); +INSERT INTO `｣ﾔ｣ｹa` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ'); +INSERT INTO `｣ﾔ｣ｹb` VALUES ('常ﾜ'); +INSERT INTO `｣ﾔ｣ｱ｣ｰa` VALUES ('竺'),('叱'),('悉'); +INSERT INTO `｣ﾔ｣ｱ｣ｰb` VALUES ('竺'); +INSERT INTO `｣ﾔ｣ｱ｣ｱa` VALUES ('､｢'),('､ｫ'),('､ｵ'); +INSERT INTO `｣ﾔ｣ｱ｣ｱb` VALUES ('､｢'); +INSERT INTO `｣ﾔ｣ｱ｣ｲa` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ'); +INSERT INTO `｣ﾔ｣ｱ｣ｲb` VALUES ('常ﾜ'); +SELECT * FROM `｣ﾔ｣ｱa` JOIN `｣ﾔ｣ｱb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｱa` INNER JOIN `｣ﾔ｣ｱb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｱa` JOIN `｣ﾔ｣ｱb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｱa` INNER JOIN `｣ﾔ｣ｱb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｱa` CROSS JOIN `｣ﾔ｣ｱb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｱa` LEFT JOIN `｣ﾔ｣ｱb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｱa` LEFT JOIN `｣ﾔ｣ｱb` ON (`｣ﾔ｣ｱa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｱb` RIGHT JOIN `｣ﾔ｣ｱa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｱb` RIGHT JOIN `｣ﾔ｣ｱa` ON (`｣ﾔ｣ｱa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｲa` JOIN `｣ﾔ｣ｲb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｲa` INNER JOIN `｣ﾔ｣ｲb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｲa` JOIN `｣ﾔ｣ｲb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｲa` INNER JOIN `｣ﾔ｣ｲb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｲa` CROSS JOIN `｣ﾔ｣ｲb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｲa` LEFT JOIN `｣ﾔ｣ｲb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｲa` LEFT JOIN `｣ﾔ｣ｲb` ON (`｣ﾔ｣ｲa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｲb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｲb` RIGHT JOIN `｣ﾔ｣ｲa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｲb` RIGHT JOIN `｣ﾔ｣ｲa` ON (`｣ﾔ｣ｲa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｲb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｳa` JOIN `｣ﾔ｣ｳb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｳa` INNER JOIN `｣ﾔ｣ｳb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｳa` JOIN `｣ﾔ｣ｳb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｳa` INNER JOIN `｣ﾔ｣ｳb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｳa` CROSS JOIN `｣ﾔ｣ｳb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｳa` LEFT JOIN `｣ﾔ｣ｳb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｳa` LEFT JOIN `｣ﾔ｣ｳb` ON (`｣ﾔ｣ｳa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｳb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｳb` RIGHT JOIN `｣ﾔ｣ｳa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｳb` RIGHT JOIN `｣ﾔ｣ｳa` ON (`｣ﾔ｣ｳa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｳb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｴa` JOIN `｣ﾔ｣ｴb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｴa` INNER JOIN `｣ﾔ｣ｴb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｴa` JOIN `｣ﾔ｣ｴb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｴa` INNER JOIN `｣ﾔ｣ｴb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｴa` CROSS JOIN `｣ﾔ｣ｴb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｴa` LEFT JOIN `｣ﾔ｣ｴb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｴa` LEFT JOIN `｣ﾔ｣ｴb` ON (`｣ﾔ｣ｴa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｴb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｴb` RIGHT JOIN `｣ﾔ｣ｴa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｴb` RIGHT JOIN `｣ﾔ｣ｴa` ON (`｣ﾔ｣ｴa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｴb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｵa` JOIN `｣ﾔ｣ｵb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｵa` INNER JOIN `｣ﾔ｣ｵb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｵa` JOIN `｣ﾔ｣ｵb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｵa` INNER JOIN `｣ﾔ｣ｵb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｵa` CROSS JOIN `｣ﾔ｣ｵb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｵa` LEFT JOIN `｣ﾔ｣ｵb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｵa` LEFT JOIN `｣ﾔ｣ｵb` ON (`｣ﾔ｣ｵa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｵb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｵb` RIGHT JOIN `｣ﾔ｣ｵa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｵb` RIGHT JOIN `｣ﾔ｣ｵa` ON (`｣ﾔ｣ｵa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｵb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｶa` JOIN `｣ﾔ｣ｶb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｶa` INNER JOIN `｣ﾔ｣ｶb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｶa` JOIN `｣ﾔ｣ｶb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｶa` INNER JOIN `｣ﾔ｣ｶb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｶa` CROSS JOIN `｣ﾔ｣ｶb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｶa` LEFT JOIN `｣ﾔ｣ｶb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｶa` LEFT JOIN `｣ﾔ｣ｶb` ON (`｣ﾔ｣ｶa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｶb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｶb` RIGHT JOIN `｣ﾔ｣ｶa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｶb` RIGHT JOIN `｣ﾔ｣ｶa` ON (`｣ﾔ｣ｶa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｶb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｷa` JOIN `｣ﾔ｣ｷb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｷa` INNER JOIN `｣ﾔ｣ｷb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｷa` JOIN `｣ﾔ｣ｷb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｷa` INNER JOIN `｣ﾔ｣ｷb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｷa` CROSS JOIN `｣ﾔ｣ｷb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｷa` LEFT JOIN `｣ﾔ｣ｷb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｷa` LEFT JOIN `｣ﾔ｣ｷb` ON (`｣ﾔ｣ｷa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｷb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｷb` RIGHT JOIN `｣ﾔ｣ｷa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｷb` RIGHT JOIN `｣ﾔ｣ｷa` ON (`｣ﾔ｣ｷa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｷb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｸa` JOIN `｣ﾔ｣ｸb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｸa` INNER JOIN `｣ﾔ｣ｸb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｸa` JOIN `｣ﾔ｣ｸb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｸa` INNER JOIN `｣ﾔ｣ｸb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｸa` CROSS JOIN `｣ﾔ｣ｸb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｸa` LEFT JOIN `｣ﾔ｣ｸb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｸa` LEFT JOIN `｣ﾔ｣ｸb` ON (`｣ﾔ｣ｸa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｸb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｸb` RIGHT JOIN `｣ﾔ｣ｸa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｸb` RIGHT JOIN `｣ﾔ｣ｸa` ON (`｣ﾔ｣ｸa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｸb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｹa` JOIN `｣ﾔ｣ｹb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｹa` INNER JOIN `｣ﾔ｣ｹb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｹa` JOIN `｣ﾔ｣ｹb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｹa` INNER JOIN `｣ﾔ｣ｹb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｹa` CROSS JOIN `｣ﾔ｣ｹb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｹa` LEFT JOIN `｣ﾔ｣ｹb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｹa` LEFT JOIN `｣ﾔ｣ｹb` ON (`｣ﾔ｣ｹa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｹb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｹb` RIGHT JOIN `｣ﾔ｣ｹa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｹb` RIGHT JOIN `｣ﾔ｣ｹa` ON (`｣ﾔ｣ｹa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｹb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` JOIN `｣ﾔ｣ｱ｣ｰb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` INNER JOIN `｣ﾔ｣ｱ｣ｰb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` JOIN `｣ﾔ｣ｱ｣ｰb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` INNER JOIN `｣ﾔ｣ｱ｣ｰb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` CROSS JOIN `｣ﾔ｣ｱ｣ｰb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 竺 +悉 竺 +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` LEFT JOIN `｣ﾔ｣ｱ｣ｰb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｱ｣ｰa` LEFT JOIN `｣ﾔ｣ｱ｣ｰb` ON (`｣ﾔ｣ｱ｣ｰa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱ｣ｰb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +叱 NULL +悉 NULL +SELECT * FROM `｣ﾔ｣ｱ｣ｰb` RIGHT JOIN `｣ﾔ｣ｱ｣ｰa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｱ｣ｰb` RIGHT JOIN `｣ﾔ｣ｱ｣ｰa` ON (`｣ﾔ｣ｱ｣ｰa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱ｣ｰb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +竺 竺 +NULL 叱 +NULL 悉 +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` JOIN `｣ﾔ｣ｱ｣ｱb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` INNER JOIN `｣ﾔ｣ｱ｣ｱb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` JOIN `｣ﾔ｣ｱ｣ｱb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` INNER JOIN `｣ﾔ｣ｱ｣ｱb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` CROSS JOIN `｣ﾔ｣ｱ｣ｱb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ ､｢ +､ｵ ､｢ +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` LEFT JOIN `｣ﾔ｣ｱ｣ｱb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｱ｣ｱa` LEFT JOIN `｣ﾔ｣ｱ｣ｱb` ON (`｣ﾔ｣ｱ｣ｱa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱ｣ｱb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +､ｫ NULL +､ｵ NULL +SELECT * FROM `｣ﾔ｣ｱ｣ｱb` RIGHT JOIN `｣ﾔ｣ｱ｣ｱa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｱ｣ｱb` RIGHT JOIN `｣ﾔ｣ｱ｣ｱa` ON (`｣ﾔ｣ｱ｣ｱa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱ｣ｱb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +､｢ ､｢ +NULL ､ｫ +NULL ､ｵ +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` JOIN `｣ﾔ｣ｱ｣ｲb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` INNER JOIN `｣ﾔ｣ｱ｣ｲb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` JOIN `｣ﾔ｣ｱ｣ｲb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` INNER JOIN `｣ﾔ｣ｱ｣ｲb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` CROSS JOIN `｣ﾔ｣ｱ｣ｲb`; +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ 常ﾜ +常ﾞ 常ﾜ +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` LEFT JOIN `｣ﾔ｣ｱ｣ｲb` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｱ｣ｲa` LEFT JOIN `｣ﾔ｣ｱ｣ｲb` ON (`｣ﾔ｣ｱ｣ｲa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱ｣ｲb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +常ﾝ NULL +常ﾞ NULL +SELECT * FROM `｣ﾔ｣ｱ｣ｲb` RIGHT JOIN `｣ﾔ｣ｱ｣ｲa` USING (`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +SELECT * FROM `｣ﾔ｣ｱ｣ｲb` RIGHT JOIN `｣ﾔ｣ｱ｣ｲa` ON (`｣ﾔ｣ｱ｣ｲa`.`｣ﾃ｣ｱ` = `｣ﾔ｣ｱ｣ｲb`.`｣ﾃ｣ｱ`); +｣ﾃ｣ｱ ｣ﾃ｣ｱ +常ﾜ 常ﾜ +NULL 常ﾝ +NULL 常ﾞ +DROP TABLE `｣ﾔ｣ｱa`; +DROP TABLE `｣ﾔ｣ｱb`; +DROP TABLE `｣ﾔ｣ｲa`; +DROP TABLE `｣ﾔ｣ｲb`; +DROP TABLE `｣ﾔ｣ｳa`; +DROP TABLE `｣ﾔ｣ｳb`; +DROP TABLE `｣ﾔ｣ｴa`; +DROP TABLE `｣ﾔ｣ｴb`; +DROP TABLE `｣ﾔ｣ｵa`; +DROP TABLE `｣ﾔ｣ｵb`; +DROP TABLE `｣ﾔ｣ｶa`; +DROP TABLE `｣ﾔ｣ｶb`; +DROP TABLE `｣ﾔ｣ｷa`; +DROP TABLE `｣ﾔ｣ｷb`; +DROP TABLE `｣ﾔ｣ｸa`; +DROP TABLE `｣ﾔ｣ｸb`; +DROP TABLE `｣ﾔ｣ｹa`; +DROP TABLE `｣ﾔ｣ｹb`; +DROP TABLE `｣ﾔ｣ｱ｣ｰa`; +DROP TABLE `｣ﾔ｣ｱ｣ｰb`; +DROP TABLE `｣ﾔ｣ｱ｣ｱa`; +DROP TABLE `｣ﾔ｣ｱ｣ｱb`; +DROP TABLE `｣ﾔ｣ｱ｣ｲa`; +DROP TABLE `｣ﾔ｣ｱ｣ｲb`; |