mysql> select * from str;
+----+-----------+-----------+
| id | string | scenario |
+----+-----------+-----------+
| 1 | dddd | |
| 2 | ssssff | ffff |
| 3 | 1231 | 23123123 |
| 4 | 123123123 | 123123123 |
| 5 | ssssff | ffff |
| 6 | asdfas | fffffdsdf |
+----+-----------+-----------+
6 rows in set (0.00 sec)
mysql> select * from str1;
+------+------+
| s_id | tag |
+------+------+
| 1 | 33 |
| 4 | aas |
| 5 | asdf |
| 7 | sdf |
| 8 | asdf |
+------+------+
5 rows in set (0.00 sec)
mysql> select * from str s left join str1 t on s.id = t.s_id;
+----+-----------+-----------+------+------+
| id | string | scenario | s_id | tag |
+----+-----------+-----------+------+------+
| 1 | dddd | | 1 | 33 |
| 2 | ssssff | ffff | NULL | NULL |
| 3 | 1231 | 23123123 | NULL | NULL |
| 4 | 123123123 | 123123123 | 4 | aas |
| 5 | ssssff | ffff | 5 | asdf |
| 6 | asdfas | fffffdsdf | NULL | NULL |
+----+-----------+-----------+------+------+
6 rows in set (0.00 sec)
mysql> select * from str s right join str1 t on s.id = t.s_id;
+------+-----------+-----------+------+------+
| id | string | scenario | s_id | tag |
+------+-----------+-----------+------+------+
| 1 | dddd | | 1 | 33 |
| 4 | 123123123 | 123123123 | 4 | aas |
| 5 | ssssff | ffff | 5 | asdf |
| NULL | NULL | NULL | 7 | sdf |
| NULL | NULL | NULL | 8 | asdf |
+------+-----------+-----------+------+------+
5 rows in set (0.00 sec)
mysql> select * from str s inner join str1 t on s.id = t.s_id;
+----+-----------+-----------+------+------+
| id | string | scenario | s_id | tag |
+----+-----------+-----------+------+------+
| 1 | dddd | | 1 | 33 |
| 4 | 123123123 | 123123123 | 4 | aas |
| 5 | ssssff | ffff | 5 | asdf |
+----+-----------+-----------+------+------+
3 rows in set (0.00 sec)
mysql> select * from str s inner join str1 t ;
+----+-----------+-----------+------+------+
| id | string | scenario | s_id | tag |
+----+-----------+-----------+------+------+
| 1 | dddd | | 1 | 33 |
| 1 | dddd | | 4 | aas |
| 1 | dddd | | 5 | asdf |
| 1 | dddd | | 7 | sdf |
| 1 | dddd | | 8 | asdf |
| 2 | ssssff | ffff | 1 | 33 |
| 2 | ssssff | ffff | 4 | aas |
| 2 | ssssff | ffff | 5 | asdf |
| 2 | ssssff | ffff | 7 | sdf |
| 2 | ssssff | ffff | 8 | asdf |
| 3 | 1231 | 23123123 | 1 | 33 |
| 3 | 1231 | 23123123 | 4 | aas |
| 3 | 1231 | 23123123 | 5 | asdf |
| 3 | 1231 | 23123123 | 7 | sdf |
| 3 | 1231 | 23123123 | 8 | asdf |
| 4 | 123123123 | 123123123 | 1 | 33 |
| 4 | 123123123 | 123123123 | 4 | aas |
| 4 | 123123123 | 123123123 | 5 | asdf |
| 4 | 123123123 | 123123123 | 7 | sdf |
| 4 | 123123123 | 123123123 | 8 | asdf |
| 5 | ssssff | ffff | 1 | 33 |
| 5 | ssssff | ffff | 4 | aas |
| 5 | ssssff | ffff | 5 | asdf |
| 5 | ssssff | ffff | 7 | sdf |
| 5 | ssssff | ffff | 8 | asdf |
| 6 | asdfas | fffffdsdf | 1 | 33 |
| 6 | asdfas | fffffdsdf | 4 | aas |
| 6 | asdfas | fffffdsdf | 5 | asdf |
| 6 | asdfas | fffffdsdf | 7 | sdf |
| 6 | asdfas | fffffdsdf | 8 | asdf |
+----+-----------+-----------+------+------+
30 rows in set (0.00 sec)
