mysql 存储过程 while 报错,[已解决]新建mysql的存储过程报错，麻烦帮看看哪里不对...

mysql> delimiter //

mysql> create procedure rong()

-> begin

-> select * from student;

-> end //

Query OK, 0 rows affected (0.00 sec)

mysql存储过程批量插入数据

->delimiter //

-> create procedure huan()

-> begin

-> declare i int;

-> set i=2;

-> while i<100 do

-> insert into student(id,name,sex)values(i,'huan','girl');

-> set i=i+1;

-> end while;

-> end //

Query OK, 0 rows affected (0.00 sec)

执行存储过程，插入数据

call huan

oracle存储过程批量插入数据

create or replace procedure rong

is

i integer;

begin

i := 1;

loop

insert into student_info(id,name,gender,describe,blogsite)values(i,'cuihuanhuan','girl','dddd','baidu.com');

i := i + 1;

exit when i > 100;

end loop;

end;

不缩进也没事

exec rong;

commit；

这样就成功插入100条数据了

sqlserver存储过程批量插入数据

declare @i bigint;

set @i=1

while(@i<=5000)

begin

insert into student_info(id,name,gender,comment,blogsite)values(@i,'cuiuanhuan','girl','自卫','baidu.com')

set @i=@i+1

end