qq_41829492的博客

MySql逗号拼接的列拆分为多行效果展示实现的SQL涉及的知识点实现的SQL解析效果展示某字段的值：实现的效果，一列转为多行：实现的SQLSELECT SUBSTRING_INDEX(SUBSTRING_INDEX('7654,7698,7782,7788',',',help_topic_id+1),',',-1) AS num FROM mysql.help...

SELECT a.managecom, a.subtype, count(*) loadsucc, sum(case when a.state in ('4', '5', '6', '7', '8', '9') then 1 else 0 end) recogsucc, sum(case when a.state in ...