mysql> delimiter //mysql> create procedure rong -> begin -> select * from student; -> end //ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'beginselect * from student;end' at line 2mysql>
解决方案
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 rongis 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=1while(@i<=5000)begin insert into student_info(id,name,gender,comment,blogsite)values(@i,'cuiuanhuan','girl','自卫','baidu.com') set @i=@i+1end