mysql存储过程批量提交_mysql执行存储过程批量插入随机数据

创建存储过程，执行

drop procedure if exists u_head_and_low_pro;

delimiter //

create procedure u_head_and_low_pro()

begin

DECLARE n int DEFAULT 0;

WHILE n < 1000 DO

insert into activity(data_code, coupon_activity_number, coupon_activity_title, coupon_activity_category,

coupon_activity_type, product_type, coupon_type, currency_type, full_amount,

decrease_amount, total_amount, take_amount, untake_amount, used_amount, per_user_limit,

effective_caculate_mode, begin_effective_time, end_effective_time,

coupon_activity_status, remark, create_by, create_time, update_by, update_time,

del_flag, lock_version)

values (CONCAT('248681711918', LPAD((@i:=n + 1), 4, 0)), left (upper (replace(uuid(), '-', '')), 5),

"活动", 2, 2, 2, 1, "HKD", 1000, 100, 1, 0, 1, 0, 1, 1, "2017-02-01 00:00:00",

"2018-02-25 23:59:59", 1, "后台批量添加1000条数据", "system", now(), "system", now(), 0, 0);

set n = n + 1;

END WHILE;

commit;

end;;

call u_head_and_low_pro();

将查询结果批量插入另一张表

insert into rule(data_code,coupon_activity_code,trip_type, begin_departure_time,end_departure_time,departure_days,remark,create_by,create_time,update_by,update_time,

del_flag,lock_version)

select

CONCAT('258681711911', LPAD((@i:=@i + 1), 4, 0)) AS data_code,

couponActivity.data_code,

'["1","2"]',"2017-12-01 00:00:00","2018-09-01 23:59:59",'["1","2","3","4","5","6","7"]',

"后台批量添加1000条数据","system",now(),"system",now(),0,0

from activity as couponActivity,(select @i:=0) as it