mysql创建存储过程造数据

delimiter $$$
DROP PROCEDURE zqtest6;
create procedure zqtest6()
begin
declare i int default 0;
set i=1;
start transaction;
while i<100do
// insert into tablename (columnname) values (i);
set i=i+1;
end while;
commit;
end
$$$
delimiter;
call zqtest6();

 

posted @ 2022-03-21 09:19  _titleInfo  阅读(92)  评论(0编辑  收藏  举报
//雪花飘落效果