MYSQL分割字符串列转行

1#准备示例数据
2create table tbl_name (ID int ,mSize varchar(100));
3insert into tbl_name values (1,'tiny,small,big');
4insert into tbl_name values (2,'small,medium');
5insert into tbl_name values (3,'tiny,big');
6
7#用于行列转换循环的自增表
8create table incre_table (AutoIncreID int);
9insert into incre_table values (1);
10insert into incre_table values (2);
11insert into incre_table values (3);
12 
13
14select a.ID,substring_index(substring_index(a.mSize,',',b.help_topic_id+1),',',-1) 
15from 
16tbl_name a
17join
18mysql.help_topic b
19on b.help_topic_id < (length(a.mSize) - length(replace(a.mSize,',',''))+1)
20order by a.ID;