--创造随机数
--创造from_num 到 to_num 的整数,包左不包右
delimiter $$
drop function if exists `rand_num` $$
create definer=`root`@`123` function `rand_num` (from_num int , to_num int) returns int(10)
begin
declare i int default 0;
set i = floor(from_num + rand() * (to_num - from_num + 1));
return i ;
end $$
delimiter ;
三:存储过程
delimiter $$
drop procedure if exists `test_pro` $$
create definer=`root`@`123` procedure `test_pro` (data_date varchar(20) , sum int )
begin
declare i int default 0;
declare dd datetime default null ;
repeat
set i = i + 1 ;
set dd = date_add(data_date , -1) ;
insert into table customer_info (id,name,address,dt) values (i,'小明','深圳',dd) ;
until i = sum
end repeat ;
commit ;
end $$
delimiter ;