Mysql表随机添加测试数据

SET GLOBAL log_bin_trust_function_creators = 1;

create function rn()
returns smallint
begin
declare res smallint default 0;
set res=floor(1+rand()*3000) ; #这里1和3000的位置可以更改为你需要的范围。
return res;
end;

create function rs(n int)
returns varchar(1024)
begin
declare chars char(52) default 'abcdefghijklmnopqrstuvwxyzABCDEFJHIJKLMNOPQRSTUVWXYZ';
declare res varchar(1024) default '';
declare i int default 0;
repeat
set i = i + 1;
set res = concat(res,substring(chars,floor(1+rand()*52),1));
until i=n end repeat;
return res;
end;

create procedure instforum(n int)
begin
declare i int default 0;
set autocommit = 0;
repeat
set i = i + 1;
insert into t_forum (title,remark,author,type,size,duration) 
values(rs(150),rs(200),rs(20),1,rn(),rs(10));
until i=n  end repeat;
commit;
set autocommit = 1;
end;

call instforum(50)