已知条件
①表:tb_student
SELECT * FROM tb_student
需求:
将tb_student的【name】列全部合并为一个值,并且合并的值通过”逗号“分隔
SELECT GROUP_CONCAT(name SEPARATOR ',') AS newName FROM tb_student
已知条件
①表:tb_student
SELECT * FROM tb_student
需求:
将tb_student的【name】列全部合并为一个值,并且合并的值通过”逗号“分隔
SELECT GROUP_CONCAT(name SEPARATOR ',') AS newName FROM tb_student