Question

请问mysql的insert 语句存储过程怎样写啊 给个例子就系了，谢谢啊！

Answer 1

delimiter //
下面首先使用第一种循环编写一个例子。
mysql> create procedure pro10()
-> begin
-> declare i int;
-> set i=0;
-> while i<5 do
-> insert into t1(filed) values(i);
-> set i=i+1;
-> end while;
-> end;//
delimiter;
Query OK, 0 rows affected (0.00 sec)

mysql> call pro10(100);