Created
October 11, 2019 11:45
-
-
Save DQinYuan/5e2b4b918e628fb068f1a332a5884c6a to your computer and use it in GitHub Desktop.
sub_query_test.yy
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE table_20_utf8_undef SET `col_bigint_undef_unsigned` < 95 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_90_latin1_undef); | |
| SELECT * FROM table_30_latin1_4; | |
| SELECT * FROM table_30_latin1_4; | |
| SELECT * FROM (SELECT `col_varchar(20)_key_signed` FROM table_90_latin1_undef) INNER JOIN (SELECT `col_char(20)_undef_signed` FROM table_30_utf8_4) ON `col_char(20)_key_signed` = `col_char(20)_key_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_utf8_4); | |
| UPDATE table_90_utf8_4 SET `col_bigint_key_signed` < -93 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_20_utf8_6); | |
| SELECT `col_char(20)_undef_signed` FROM table_10_utf8_undef; | |
| SELECT * FROM table_90_latin1_undef; | |
| UPDATE table_10_binary_6 SET `col_bigint_undef_unsigned` < 32 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT `col_varchar(20)_undef_signed` FROM table_10_latin1_undef) WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_latin1_6)); | |
| UPDATE table_30_utf8_4 SET `col_bigint_undef_signed` < -19 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_90_latin1_4) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_90_binary_undef)); | |
| SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM (SELECT `col_varchar(20)_undef_signed` FROM table_20_latin1_undef) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_utf8_6)) WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_latin1_undef); | |
| UPDATE table_10_binary_6 SET `col_bigint_key_unsigned` < -116 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_90_binary_6); | |
| UPDATE table_10_binary_undef SET `col_bigint_undef_signed` < -63 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT `col_varchar(20)_key_signed` FROM table_30_binary_4) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_10_utf8_6)); | |
| SELECT * FROM table_30_latin1_undef; | |
| SELECT `col_char(20)_undef_signed` FROM (SELECT `col_varchar(20)_key_signed` FROM table_90_binary_4) WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT * FROM table_90_latin1_6) WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_30_binary_undef)); | |
| SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM (SELECT * FROM (SELECT `col_char(20)_undef_signed` FROM table_20_binary_undef) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_10_utf8_6)) INNER JOIN (SELECT * FROM table_10_utf8_6) ON `col_char(20)_key_signed` = `col_varchar(20)_key_signed` WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_90_binary_6)) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_10_latin1_4); | |
| UPDATE table_20_binary_4 SET `col_bigint_key_signed` < -18 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_utf8_4); | |
| UPDATE table_10_latin1_6 SET `col_bigint_undef_unsigned` < -51 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_30_binary_6); | |
| SELECT `col_char(20)_undef_signed` FROM table_10_binary_undef; | |
| SELECT `col_varchar(20)_key_signed` FROM (SELECT `col_char(20)_key_signed` FROM table_20_latin1_4) WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_90_latin1_4); | |
| SELECT `col_varchar(20)_key_signed` FROM table_10_binary_undef; | |
| UPDATE table_20_binary_4 SET `col_bigint_key_unsigned` < 57 WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_90_binary_4); | |
| UPDATE table_10_utf8_4 SET `col_bigint_key_signed` < -75 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_latin1_6); | |
| UPDATE table_90_binary_4 SET `col_bigint_undef_signed` < -108 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT `col_char(20)_undef_signed` FROM (SELECT `col_varchar(20)_key_signed` FROM table_90_binary_6) WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT * FROM table_10_utf8_6) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_90_latin1_4))) INNER JOIN (SELECT * FROM table_10_binary_undef) ON `col_char(20)_key_signed` = `col_char(20)_key_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_30_utf8_undef)); | |
| UPDATE table_10_latin1_4 SET `col_bigint_key_unsigned` < 82 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT * FROM table_10_utf8_6) INNER JOIN (SELECT `col_char(20)_undef_signed` FROM table_20_binary_4) ON `col_varchar(20)_key_signed` = `col_char(20)_undef_signed` WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_90_latin1_4)); | |
| UPDATE table_90_latin1_6 SET `col_bigint_undef_unsigned` < -128 WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_30_binary_4); | |
| UPDATE table_90_utf8_4 SET `col_bigint_key_signed` < 56 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_30_utf8_undef); | |
| UPDATE table_10_utf8_4 SET `col_bigint_undef_signed` < -38 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT * FROM table_20_latin1_6) INNER JOIN (SELECT `col_varchar(20)_undef_signed` FROM table_90_binary_undef) ON `col_varchar(20)_undef_signed` = `col_char(20)_key_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_30_binary_undef)); | |
| UPDATE table_20_latin1_4 SET `col_bigint_key_unsigned` < 123 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT * FROM (SELECT `col_char(20)_key_signed` FROM table_10_utf8_6) WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_10_latin1_4) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_90_binary_undef))) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_90_binary_4)); | |
| SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_90_latin1_6) INNER JOIN (SELECT `col_varchar(20)_undef_signed` FROM table_30_binary_6) ON `col_char(20)_key_signed` = `col_char(20)_undef_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_30_latin1_4); | |
| SELECT `col_char(20)_key_signed` FROM table_30_latin1_4; | |
| UPDATE table_20_binary_4 SET `col_bigint_key_signed` < -68 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_binary_undef); | |
| UPDATE table_10_utf8_undef SET `col_bigint_undef_unsigned` < -44 WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT * FROM table_30_binary_4) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_20_utf8_undef)); | |
| UPDATE table_90_latin1_6 SET `col_bigint_undef_unsigned` < -47 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_20_binary_4); | |
| SELECT * FROM table_20_binary_undef; | |
| SELECT `col_char(20)_undef_signed` FROM table_30_utf8_undef; | |
| UPDATE table_20_binary_6 SET `col_bigint_key_signed` < 119 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_20_binary_6); | |
| SELECT * FROM (SELECT `col_char(20)_key_signed` FROM table_30_binary_undef) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_20_utf8_6); | |
| SELECT `col_char(20)_undef_signed` FROM table_20_binary_6; | |
| SELECT * FROM table_10_utf8_undef; | |
| SELECT * FROM table_10_binary_6; | |
| UPDATE table_10_latin1_undef SET `col_bigint_undef_unsigned` < -69 WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT * FROM table_90_latin1_6) WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_20_utf8_6) INNER JOIN (SELECT * FROM table_30_binary_4) ON `col_varchar(20)_undef_signed` = `col_varchar(20)_key_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_10_latin1_4))); | |
| UPDATE table_30_latin1_4 SET `col_bigint_undef_signed` < 76 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_20_latin1_4); | |
| SELECT * FROM table_10_latin1_4; | |
| SELECT `col_char(20)_key_signed` FROM table_20_binary_4; | |
| UPDATE table_30_latin1_4 SET `col_bigint_key_signed` < 63 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT * FROM table_90_utf8_undef) INNER JOIN (SELECT `col_varchar(20)_undef_signed` FROM table_10_binary_6) ON `col_varchar(20)_key_signed` = `col_varchar(20)_undef_signed` WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_30_binary_undef)); | |
| UPDATE table_20_binary_undef SET `col_bigint_undef_unsigned` < -37 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_binary_undef); | |
| UPDATE table_30_utf8_6 SET `col_bigint_undef_signed` < -8 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_90_binary_4); | |
| UPDATE table_10_utf8_6 SET `col_bigint_key_signed` < -63 WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_latin1_4); | |
| SELECT `col_varchar(20)_key_signed` FROM table_30_binary_undef; | |
| UPDATE table_90_binary_undef SET `col_bigint_key_unsigned` < -55 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT `col_varchar(20)_undef_signed` FROM table_90_utf8_4) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_20_latin1_6)); | |
| SELECT * FROM (SELECT `col_char(20)_key_signed` FROM table_30_utf8_4) WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_latin1_undef); | |
| SELECT `col_char(20)_key_signed` FROM (SELECT * FROM table_20_latin1_undef) WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_20_utf8_4); | |
| UPDATE table_90_latin1_6 SET `col_bigint_undef_signed` < -85 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_30_binary_6); | |
| SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_20_binary_4) WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT `col_char(20)_key_signed` FROM table_90_latin1_4) WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_10_latin1_4)); | |
| SELECT `col_char(20)_undef_signed` FROM table_30_utf8_6; | |
| SELECT * FROM table_90_latin1_4; | |
| SELECT * FROM table_30_latin1_undef; | |
| SELECT `col_varchar(20)_key_signed` FROM table_10_binary_6; | |
| SELECT `col_char(20)_key_signed` FROM table_90_binary_6; | |
| SELECT `col_varchar(20)_undef_signed` FROM table_90_latin1_4; | |
| SELECT * FROM (SELECT * FROM table_20_binary_undef) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_20_utf8_6); | |
| SELECT * FROM (SELECT * FROM table_90_latin1_6) WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_utf8_undef); | |
| SELECT * FROM table_20_latin1_6; | |
| UPDATE table_20_binary_6 SET `col_bigint_undef_unsigned` < 4 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_20_utf8_4); | |
| UPDATE table_30_utf8_4 SET `col_bigint_key_unsigned` < 125 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_30_binary_4); | |
| UPDATE table_30_binary_6 SET `col_bigint_key_signed` < -8 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT `col_varchar(20)_key_signed` FROM (SELECT * FROM table_30_binary_undef) INNER JOIN (SELECT `col_char(20)_key_signed` FROM (SELECT * FROM table_90_latin1_4) INNER JOIN (SELECT `col_char(20)_undef_signed` FROM table_90_latin1_4) ON `col_varchar(20)_key_signed` = `col_varchar(20)_undef_signed` WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_latin1_undef)) ON `col_char(20)_undef_signed` = `col_char(20)_key_signed` WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM (SELECT `col_char(20)_undef_signed` FROM table_10_binary_4) INNER JOIN (SELECT * FROM (SELECT `col_char(20)_undef_signed` FROM table_90_binary_4) INNER JOIN (SELECT * FROM table_10_binary_6) ON `col_char(20)_key_signed` = `col_varchar(20)_undef_signed` WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_90_utf8_4)) ON `col_char(20)_undef_signed` = `col_varchar(20)_key_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_90_utf8_undef))) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT `col_char(20)_undef_signed` FROM table_90_latin1_4) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_10_utf8_undef))); | |
| SELECT `col_varchar(20)_key_signed` FROM table_30_binary_6; | |
| SELECT `col_char(20)_key_signed` FROM table_20_binary_undef; | |
| SELECT * FROM table_10_latin1_undef; | |
| SELECT * FROM (SELECT * FROM table_10_latin1_4) WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_10_binary_4); | |
| SELECT `col_char(20)_undef_signed` FROM table_90_latin1_6; | |
| SELECT * FROM table_30_utf8_4; | |
| UPDATE table_90_latin1_undef SET `col_bigint_key_signed` < -107 WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT * FROM table_20_binary_4) INNER JOIN (SELECT `col_char(20)_key_signed` FROM table_90_binary_undef) ON `col_char(20)_key_signed` = `col_char(20)_undef_signed` WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_utf8_undef)); | |
| SELECT `col_varchar(20)_undef_signed` FROM table_90_latin1_undef; | |
| UPDATE table_20_binary_undef SET `col_bigint_key_signed` < -41 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_30_utf8_4); | |
| SELECT * FROM table_20_utf8_6; | |
| UPDATE table_90_latin1_6 SET `col_bigint_key_unsigned` < -99 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_30_utf8_4); | |
| SELECT `col_varchar(20)_key_signed` FROM table_20_latin1_4; | |
| SELECT `col_char(20)_undef_signed` FROM (SELECT * FROM table_30_utf8_undef) INNER JOIN (SELECT * FROM table_20_utf8_6) ON `col_varchar(20)_key_signed` = `col_varchar(20)_undef_signed` WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM (SELECT `col_char(20)_key_signed` FROM (SELECT `col_varchar(20)_undef_signed` FROM (SELECT `col_char(20)_key_signed` FROM table_90_utf8_6) INNER JOIN (SELECT * FROM table_90_binary_4) ON `col_varchar(20)_undef_signed` = `col_char(20)_key_signed` WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_30_binary_6)) WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_binary_4)) INNER JOIN (SELECT * FROM table_90_latin1_undef) ON `col_varchar(20)_key_signed` = `col_char(20)_undef_signed` WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM (SELECT * FROM table_20_latin1_4) WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_90_latin1_4))); | |
| SELECT `col_varchar(20)_undef_signed` FROM (SELECT `col_varchar(20)_key_signed` FROM table_30_utf8_6) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_utf8_undef); | |
| UPDATE table_30_binary_4 SET `col_bigint_undef_unsigned` < -68 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_30_latin1_undef); | |
| SELECT * FROM table_30_utf8_4; | |
| SELECT * FROM table_20_latin1_4; | |
| UPDATE table_10_latin1_6 SET `col_bigint_key_unsigned` < 97 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_90_binary_4); | |
| SELECT * FROM (SELECT `col_varchar(20)_key_signed` FROM table_30_latin1_undef) INNER JOIN (SELECT * FROM table_10_latin1_4) ON `col_varchar(20)_key_signed` = `col_varchar(20)_undef_signed` WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM table_90_binary_6); | |
| UPDATE table_30_binary_4 SET `col_bigint_undef_signed` < 40 WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT `col_char(20)_key_signed` FROM table_10_utf8_undef) WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_90_utf8_undef) WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_10_binary_6))); | |
| UPDATE table_10_utf8_4 SET `col_bigint_undef_signed` < -61 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_10_utf8_6); | |
| SELECT `col_varchar(20)_undef_signed` FROM table_90_latin1_6; | |
| SELECT * FROM table_10_utf8_4; | |
| UPDATE table_30_latin1_6 SET `col_bigint_undef_unsigned` < 13 WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT `col_char(20)_key_signed` FROM table_20_binary_undef) WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM table_10_binary_4)); | |
| SELECT * FROM table_10_binary_6; | |
| UPDATE table_90_utf8_undef SET `col_bigint_undef_unsigned` < 55 WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_30_latin1_4); | |
| SELECT * FROM (SELECT * FROM (SELECT `col_char(20)_undef_signed` FROM table_20_utf8_6) WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_90_utf8_undef)) INNER JOIN (SELECT * FROM table_30_utf8_4) ON `col_varchar(20)_undef_signed` = `col_char(20)_key_signed` WHERE `col_char(20)_key_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_30_binary_4); | |
| SELECT * FROM table_90_utf8_undef; | |
| SELECT `col_char(20)_undef_signed` FROM (SELECT `col_char(20)_undef_signed` FROM (SELECT * FROM table_10_binary_6) WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_undef_signed` FROM (SELECT `col_varchar(20)_undef_signed` FROM (SELECT * FROM table_90_binary_4) INNER JOIN (SELECT `col_char(20)_undef_signed` FROM table_10_utf8_undef) ON `col_char(20)_undef_signed` = `col_varchar(20)_undef_signed` WHERE `col_char(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_10_utf8_4)) INNER JOIN (SELECT `col_char(20)_undef_signed` FROM table_10_binary_6) ON `col_char(20)_key_signed` = `col_varchar(20)_key_signed` WHERE `col_char(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_20_utf8_undef))) WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_90_utf8_4); | |
| UPDATE table_10_utf8_undef SET `col_bigint_key_signed` < 76 WHERE `col_varchar(20)_key_signed` in (SELECT `col_varchar(20)_undef_signed` FROM table_30_utf8_4); | |
| UPDATE table_20_utf8_4 SET `col_bigint_key_unsigned` < -58 WHERE `col_char(20)_undef_signed` in (SELECT `col_varchar(20)_key_signed` FROM table_90_latin1_6); | |
| UPDATE table_90_utf8_4 SET `col_bigint_undef_unsigned` < -102 WHERE `col_varchar(20)_undef_signed` in (SELECT `col_char(20)_key_signed` FROM table_30_utf8_6); | |
| SELECT `col_char(20)_key_signed` FROM (SELECT `col_varchar(20)_undef_signed` FROM table_90_utf8_4) WHERE `col_varchar(20)_key_signed` in (SELECT `col_char(20)_key_signed` FROM table_90_binary_6); | |
| SELECT `col_varchar(20)_undef_signed` FROM table_90_utf8_6; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* innerjoin sub query and update sub query */ | |
| query: | |
| update | select | |
| update: | |
| # update sub query | |
| UPDATE _table | |
| SET _field_int < _tinyint | |
| WHERE _field_char in (select_char) | |
| select: | |
| select_all | |
| | select_char | |
| select_all: | |
| SELECT * FROM (select) inner_join | |
| where | |
| | SELECT * FROM _table | |
| select_char: | |
| SELECT _field_char FROM (select) inner_join | |
| WHERE _field_char in (select_char) | |
| | SELECT _field_char FROM _table | |
| where: | |
| WHERE _field_char in (select_char) | |
| inner_join: | |
| # inner join sub query | |
| INNER JOIN (select) ON _field_char = _field_char | |
| | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment