批量增加隨機記錄

badhot

BEGIN

DECLARE v INT;

SET v = 0;

REPEAT

select concat(
case when round((rand())*25) > 12 then char(round((rand())*25)+97) else char(round((rand())*25)+65) end,
case when round((rand())*25) > 12 then char(round((rand())*25)+97) else char(round((rand())*25)+65) end,
case when round((rand())*25) > 12 then char(round((rand())*25)+97) else char(round((rand())*25)+65) end,
case when round((rand())*25) > 12 then char(round((rand())*25)+97) else char(round((rand())*25)+65) end,
case when round((rand())*25) > 12 then char(round((rand())*25)+97) else char(round((rand())*25)+65) end,
case when round((rand())*25) > 12 then char(round((rand())*25)+97) else char(round((rand())*25)+65) end
) as keka;

insert into table1 (a,b)
        values(CONCAT('($%)F',keka),'e51d744514b334228d43dd605d556a61');
SET v = v + 1;

UNTIL v >= 5 <--

END REPEAT;
END


table1中的a是有固定的字符串+隨機的字符串組成，
但上面的執行有錯，哪位大俠幫忙改下