select a.id, substring_index(substring_index(a.username, ',', b.help_topic_id + 1), ',', -1) username from (SELECT bdt_business_manage_project_bak.PROJECT_ID as id, CONCAT(PROJECT_PDT_USER_ID,',',PROJECT_UI_USER_ID,',',PROJECT_TEST_USER_ID,',',PROJECT_DEV_USER_ID) as username FROM bdt_business_manage_project_bak) a JOIN mysql.help_topic b ON b.help_topic_id < (length(a.username) - length(REPLACE(a.username, ',', '')) + 1);
mysql_一列分多行操作,在一个表里的几行数据需要分拆成单行存储到一行中
最新推荐文章于 2022-11-19 10:21:01 发布