1. mysql> select username,sex from pikachu.member;
2. +----------+------+
3. | username | sex |
4. +----------+------+
5. | vince | boy |
6. | allen | boy |
7. | kobe | boy |
8. | grady | boy |
9. | kevin | boy |
10. | lucy | girl |
11. | lili | girl |
12. +----------+------+
13. 7 rows in set (0.00 sec)
15. mysql> select concat(username,sex) from pikachu.member;
16. +----------------------+
17. | concat(username,sex) |
18. +----------------------+
19. | vinceboy |
20. | allenboy |
21. | kobeboy |
22. | gradyboy |
23. | kevinboy |
24. | lucygirl |
25. | liligirl |
26. +----------------------+
27. 7 rows in set (0.00 sec)
29. mysql> select group_concat(username,sex) from pikachu.member;
30. +---------------------------------------------------------------+
31. | group_concat(username,sex) |
32. +---------------------------------------------------------------+
33. | vinceboy,allenboy,kobeboy,gradyboy,kevinboy,lucygirl,liligirl |
34. +---------------------------------------------------------------+
35. 1 row in set (0.00 sec)
37. mysql>
https://tts.tmooc.cn/ttsPage/NTD/NTDTN202109/INJECTION/DAY01/EXERCISE/01/index_answer.html