#产生随机字符串,用于测试数据库
drop function if exists randstr;
delimiter $$
create function test_1.randstr(num int(11)) returns char(255) #为了容易区分那个函数或者存储过程是那个数据库的,可以在函数名中加上数据库前缀test_randstr;
begin
declare str char(255) default 'q1we23r4t5y6u7i8o9p0asdfghjklzxcvbnm';
declare nums int(11);
declare returnstr char(255);
declare i int(11) default 0;
select floor(truncate(rand(),1)*36)+1 into nums;
select substring(str,nums,1) into returnstr;
#declare i int(11) default 0;
while i <num do
select floor(truncate(rand(),1)*36)+1 into nums;
select concat(substring(str,nums,1),returnstr) into returnstr;
#set returnstr=concat(substring(str,nums,1),returnstr);
set i=i+1;
end while;
return returnstr;
end
$$
delimiter ;