mysql慕课网笔记_MySQL开发技巧（二）

update user1 join

(

select id,user_name,group_concat(_mobile) as _mobile

from

(

select id,user_name,_mobile

from

(select s.id as id,u1.id as uid,u1.user_name,substring_index(substring_index(u1._mobile,',',s.id),',',-1) as _mobile from tb_sequence s

cross join

(select id,user_name,_over,_mobile,char_length(_mobile)-char_length(replace(_mobile,',',''))+1 as size from user1 ) u1 on s.id<=u1.size

) temp

group by user_name,_mobile

) t

group by user_name

) tt

on user1.user_name=tt.user_name

set user1._mobile=tt._mobile;