mysql 基础操作

CREATE PROCEDURE pro_luckdraw_user_info()
begin
declare num int;
set num=1;
while num <= 24 do
insert into pro_luckdraw_user_info(pro_luckdraw_user_info_id,account_id,user_id,amount,total_num,use_num,create_time,modify_time) VALUES(num,1111222110+num,20181128+num,300000,30,154333440000+num,154333440000+num);
set num=num+1;
end while;
commit;
end

批量增加数据，可实现测试过程中需要大量数据，如存在关联主外键数据需要进行完善