mysql 创建存储过程 （procedure）

CREATE PROCEDURE `insert_boxes`(IN total int)
BEGIN
declare i int default 1000;
while i < total+1500 do
insert into boxes (id) values (concat('XXX', LPAD(i, 4, 0)));
set i = i + 1;
end while ;
END

DROP PROCEDURE `insert_boxes`;

CALL insert_boxes(100);