delete from student;
DROP procedure if EXISTS insrt_stu;
delimiter //
create procedure insrt_stu ()
begin
declare i int default 1;
while i < 1000 do
insert into student(stu_name,stu_sex,stu_age) values (concat('本地测试',i),0,1);
set i=i+1;
end while;
end
//
delimiter ;
call insrt_stu ()
mysql循环添加数据
最新推荐文章于 2024-05-23 20:47:28 发布