mysql>desc_student;+-------+-------------+------+-----+---------+----------------+|Field|Type|Null|Key|Default|Extra|+-------+-------------+------+-----+---------+-------...
mysql> desc _student;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| stuId | int(11) | NO | PRI | NULL | auto_increment |
| _name | varchar(50) | YES | | NULL | |
| _age | int(11) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+
3 rows in set (0.05 sec)
create procedure insert_Student (_name varchar(50),_age int ,out _id int)
begin
insert into _student value(null,_name,_age);
select max(stuId) into _id from _student;
end;
提示ERROR 1327 (42000): Undeclared variable: _id错误,不知道为什么啊,_id不是我定义的输出参数吗
我用的mysql5.5,到网上找了几个列子,都是失败的,真是郁闷啊
改成一楼的那样还是提示同样的错误,而且默认的也应该就是输入参数才对啊
展开