多行转列
SELECT id,GROUP_CONCAT(CONCAT_WS(',',id,num,sid,NAME) ORDER BY id DESC SEPARATOR '. ')
FROM T_group_concat GROUP BY id;多行转列
SELECT id,GROUP_CONCAT(CONCAT_WS(',',id,num,sid,NAME) ORDER BY id DESC SEPARATOR '. ')
FROM T_group_concat GROUP BY id;