使用存储过程批量新增数据实例

@使用存储过程批量新增数据实例

delimiter $$ – //以delimiter来标记用$表示存储过程结束
create procedure pre() – //创建pre()存储方法
begin
declare i int; – /定义i变量
set i=6001;
while i<6021 do – //对i的值配置
– //数据库数据插入语句
INSERT INTO leaseback.apply_payment_order (id, pay_id, vendor_id, vendor_name,

open_bank, bank_card, total_money, total_amount, remark, apply_name, acquire_pay_time,

insert_by, insert_at, update_by, update_at, audit_state, pay_state, pay_proof, dept_name,
area, pay_channel) VALUES (i, CONCAT(‘FK20190815’,i), ‘GYS00