数据库 mysql 存储过程 调用执行

Question

mysql> delimiter $
mysql>create procedure insert_employee (pnamevarchar(50),psalary bigint,pdeptid int,OUT pid int)
begin
insert into employee (id,name,salary,deptid)values(null,pname,psalary,pdeptid);
select max(id) into pid from employee;
end;
mysql>call insert_employee ('lxq',1100,2,@pid);
mysql>$
mysql> delimiter ;
mysql> select @ pid;
为什么我最后的一句话的值是NULL，哪里错了？

Answer 1

call pro();