在mysql函数中group_concat动态改变分隔符

GROUP_CONCAT([DISTINCT] expr [,expr ...]
             [ORDER BY {unsigned_integer | col_name | expr}
                 [ASC | DESC] [,col_name ...]]
             [SEPARATOR str_val])

CREATE TABLE students (
    id INT,
    name VARCHAR(50),
    age INT
);

INSERT INTO students VALUES (1, 'Alice', 20);
INSERT INTO students VALUES (2, 'Bob', 22);
INSERT INTO students VALUES (3, 'Charlie', 21);

SELECT GROUP_CONCAT(name SEPARATOR ',') AS names
FROM students;

names
-----------------
Alice,Bob,Charlie

SELECT GROUP_CONCAT(name SEPARATOR ';') AS names
FROM students;

names
-----------------
Alice;Bob;Charlie