关于存储过程

[月亮光华]

delimiter //
create procedure p2(
in p2classid varchar(30),
in p2age int(10)
)
begin
insert into student (classid ,age)
values (p2classid,p2age)
end;
//
总是报语法错误，请教这是怎么回事？

[月亮光华]

[卖水果的net]

mysql> delimiter //
mysql>
mysql> create procedure p2(
    -> in p2classid varchar(30),
    -> in p2age int(10)
    -> )
    -> begin
    -> insert into student (classid ,age)values (p2classid,p2age);
    -> end;
    -> //
Query OK, 0 rows affected (0.02 sec)

mysql>
mysql> delimiter ;
mysql>
mysql> call p2('zhangsan', 30);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> select * from student;
+----------+------+
| classid  | age  |
+----------+------+
| zhangsan |   30 |
+----------+------+
1 row in set (0.00 sec)

mysql>
mysql> drop table student;
Query OK, 0 rows affected (0.01 sec)

mysql> drop procedure p2;
Query OK, 0 rows affected (0.00 sec)

mysql>