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
