BEGIN
declare i integer;
set i=1;
while i<=100 do
SET I=I+1;
end;
end while;
declare i integer;
set i=1;
while i<=100 do
begin
#连接当前时间和序列号实现序列号的递增,后面当前日期+序列号(5位从1开始若不够则0补齐)
insert into localtest(name,author) values('默认相册',concat (DATE_FORMAT(curdate(), '%Y%m%d'),LPAD(i, 5, 0) ));SET I=I+1;
end;
end while;
END
#效果图如下
#