转载链接:https://blog.csdn.net/Krystal_RonghuiLi/article/details/107998668
@使用存储过程批量新增数据实例
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), ‘GYS00001’, ‘一汽大众某某限公司’, ‘中国某某锦江分行’, ‘000000724124’, ‘1000.89’, ‘1’, ‘我是增加的数据’, ‘zzb00185’, ‘2019-08-16 00:00:00’, ‘zzb00185’, ‘2019-08-15 17:31:03’, NULL, NULL, ‘未提交’, ‘’, ‘’, ‘风险与资产管理中心’, ‘东城区’, ‘现金/转账支票’); set i=i+1; – //自增循环 end while; end $$ – //存储过程结束
调用存储过程 call pre();
查看已有的存储过程 show procedure status; 查看存储过程的建表语句 show create procedure pre; 删除存储过程方法 drop procedure if exists pre;
