服务器之家 > 正文
?
1
2
3
4
5
6
7
8
9
10
11
mysql> delimiter $$
mysql> create procedure p3()
mysql>
create
procedure
p3()
-> MODIFIES SQL DATA
-> BEGIN
->
BEGIN
-> set @i=0;
set
@i=0;
-> set @max=100;
@
max
=100;
-> while @i<@max do
-> while @i<@
do
-> insert into user values (@i);
insert
into
user
values
(@i);
-> set @i = @i + 1;
@i = @i + 1;
-> end while;
end
while;
-> end $$
$$
