delimiter $$
create procedure pro_insert()
begin
declare i int;
set i=1;
while i<100 do
insert into ces_damily values(i,concat('damily',i));
set i=i+1;
end while;
end$$
call pro_insert()
mySql 存储过程循环插入数据
最新推荐文章于 2024-04-29 23:58:50 发布