ccmusic-database音乐分类系统C语言接口开发

SELECT PK_ID, SJKZRZJLX, SJKZRZJDM FROM BFD.bfd_ftykhx WHERE DATA_DT

AND PK_ID IN ( -- 第一步计算每条记录的拆分数量 SELECT T

PK_ID/*, t

SJKZRZJDM AS 原始字符串_JDM, t

SJKZRZJLX AS 原始字符串_JLX, T

逗号数量, T

SPLIT_COUNT AS 应拆分行数, T

N AS 拆分序号, SUBSTRING_INDEX(SUBSTRING_INDEX(T

SJKZRZJDM, ,, T

N), ,, -

AS 拆分后的值DM, SUBSTRING_INDEX(SUBSTRING_INDEX(T

SJKZRZJLX, ,, T

N), ,, -

AS 拆分后的值LX*/ FROM (SELECT T

PK_ID, t

SJKZRZJDM, t

SJKZRZJLX, -- 计算逗号数量 LENGTH(SJKZRZJLX) - LENGTH(REPLACE(SJKZRZJLX, ,, )) AS 逗号数量, LENGTH(T

SJKZRZJLX) - LENGTH(REPLACE(T

SJKZRZJLX, ,, )) 1 AS SPLIT_COUNT -- 计算当前记录要拆分的项数逗号1 FROM BFD.bfd_ftykhx T1 WHERE DATA_DT

AND (SJKZRZJLX LIKE %B01% OR SJKZRZJLX LIKE %B08%)) T1 -- 第二步仅为当前记录生成需要的数字 INNER JOIN (SELECT row : row 1 as n from (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT

a, (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT

b, (SELECT row :

r) T2 ON T

N T

SPLIT_COUNT ORDER BY T

PK_ID, T

n);

b站9.1免费版最新版下载-b站9.1免费版最新版下载应用