SELECT
USERID,
GROUP_CONCAT(SCORE ORDER BY USERID SEPARATOR ';') SCORE
FROM
`stu`
GROUP BY USERID
separator 默认是逗号 ‘,’
MySQL
INSERT INTO JOB_USER_LINK (USER_DM, CREATE_TIME) VALUES ('8000001860603610', STR_TO_DATE('2021-11-12 08:41:11', '%Y-%m-%d %H:%i:%s'));
ORACLE
INSERT INTO JOB_USER_LINK (USER_DM, CREATE_TIME) VALUES ('8000001860603610', TO_DATE('2021-11-12 08:41:11', 'YYYY-MM-DD HH24:MI:SS'));