CREATE PROCEDUREproc_set()
BEGIN
set @i=0;
set @res='';
REPEAT
set @digit=FLOOR(RAND()*7+1);
set @s1=CONCAT('mm','',@digit,'.jpg');
set @s2=CONCAT('mm','',@digit,'s.jpg');
set @s=CONCAT(@s1,',',@s2);
set @res=CONCAT(@res,',',@s);
set @i=@i+1;
UNTIL @i>=5END REPEAT;
update tb_sku set pics =SUBSTRING(@res,2);
END