mysql 循环插入增量数据

CREATE DEFINER= XXXXXX @ % PROCEDURE PRO_taxpayer_invoice_statistical ()

BEGIN

DECLARE v_unifiedcredit_code VARCHAR(64)

DECLARE v_max_datedatetime

SELECT MAX(sii.created_on) INTO v_max_date

FROM sj_taxpayer_invoice_statistical_info sii

SELECT 1

END

已经测试，创建并运行下面的存储过程可以循环添加数据：

create procedure dowhile()

begin

declare i int default 0

start transaction

while i<50 do

insert into users(userId,userName,userPwd) values(null,concat('s00',i),123456)

set i=i+1

end while

commit

end

delimiter

---