Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- name1 genre1,genre2,genre3
- name2 genre2,genre6,genre8
- select m.name, group_concat(g.genre) from movies m, genres g
- where m.id = g.movie_id group by m.name;
- mysql> create table movies (id int, name varchar(100));
- Query OK, 0 rows affected (0.04 sec)
- mysql> create table genres (movie_id int, genre varchar(100));
- Query OK, 0 rows affected (0.02 sec)
- mysql> insert into movies values (1, 'Terminator');
- Query OK, 1 row affected (0.01 sec)
- mysql> insert into movies values (2, 'Lord of the Rings');
- Query OK, 1 row affected (0.01 sec)
- mysql> insert into genres values (1, 'action');
- Query OK, 1 row affected (0.01 sec)
- mysql> insert into genres values (1, 'sci-fi');
- Query OK, 1 row affected (0.01 sec)
- mysql> insert into genres values (2, 'fantasy');
- Query OK, 1 row affected (0.00 sec)
- mysql> insert into genres values (2, 'adventure');
- Query OK, 1 row affected (0.01 sec)
- mysql> select m.name, group_concat(g.genre) from movies m, genres g where m.id = g.movie_id group by m.name;
- +-------------------+-----------------------+
- | name | group_concat(g.genre) |
- +-------------------+-----------------------+
- | Lord of the Rings | adventure,fantasy |
- | Terminator | sci-fi,action |
- +-------------------+-----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement