刚学mysql的存储过程,在mysql控制台写语句时,不知道什么时候需要加分号,下面的语句在执行过程中,会报错,请大侠们帮忙看看。
mysql>create procedure p10()
->begin
->declare v int
->set v=0
->while v<10 do
->insert into t value(v)
->set v=v+1
->end while
->end;
mysql>create procedure p10()
->begin
->declare v int
->set v=0
->while v<10 do
->insert into t value(v)
->set v=v+1
->end while
->end;
输入你的语句
delimiter ;
mysql>delimiter $$
mysql>create procedure p10()
->begin
->declare v int
->set v=0
->while v<10 do
->insert into t value(v)
->set v=v+1
->end while
->end;$$
mysql>delimiter ;
mysql> create procedure p10()
-> begin
-> declare v int;
-> set v=0;
-> while v<10 do
-> insert into t value(v) ;
-> set v=v+1 ;
-> end while;
-> end;$$
Query OK, 0 rows affected (0.09 sec)mysql> mysql>delimiter ;
-> begin
-> declare v int;
-> set v=0;
-> while v<10 do
-> insert into t value(v) ;
-> set v=v+1 ;
-> end while;
-> end;$$
Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;
mysql>