现有需求,某个字段随机更新为0-99的任意数据:
mysql里的随机数试了下:
select RAND()
100以内取整(范围:[0,100)):
select FLOOR(RAND()*100)
使用存储过程写循环(循环方式有多种,这里写一种):
drop PROCEDURE IF EXISTS doloop;
create PROCEDURE doloop()
BEGIN
DECLARE i int;
set i = 1;
while i < 250001 do
update sc sc set sc.c_id = (select FLOOR(RAND()*100)) where sc.sc_id = i;
set i = i+1;
end while;
END
执行存储过程:
CALL doloop();