Chinaunix

标题: 批量增加隨機記錄 [打印本页]

---

作者: badhot    时间: 2009-05-08 16:45
标题: 批量增加隨機記錄
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是有固定的字符串+隨機的字符串組成，
但上面的執行有錯，哪位大俠幫忙改下

---

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)

Powered by Discuz! X3.2