mysql group concat 拆分,MySQL GROUP_CONCAT与COLUMN SPLIT

I am working with a TABLE, need logical help.

Check the below URL for the table structure and sample data.

Table Schema:

CREATE TABLE test (

ID INTEGER,

NAME VARCHAR (50),

VALUE INTEGER

);

Inserted Data:

INSERT INTO test VALUES (1, 'A', 4);

INSERT INTO test VALUES (1, 'B', 5);

INSERT INTO test VALUES (1, 'C', 8);

INSERT INTO test VALUES (2, 'D', 9);

INSERT INTO test VALUES (2, 'E', 9);

INSERT INTO test VALUES (3, 'F', 9);

INSERT INTO test VALUES (3, 'G', 9);

INSERT INTO test VALUES (3, 'H', 9);

INSERT INTO test VALUES (3, 'I', 9);

Query:

SELECT ID, GROUP_CONCAT(NAME) AS CODE

FROM test

GROUP BY ID;

OutPUT:

ID CODE

1 A,B,C