Question

存储过程在mysql5.1有返回但是在5.3或5.5无返回，怎么处理

Answer 1

DROP FUNCTION IF EXISTS sp_login $$
CREATE FUNCTION sp_login( userID VARCHAR(20), passPwd VARCHAR(20)) RETURNS INT(1)
BEGIN
DECLARE flag INT default 5;
DECLARE B BOOLEAN;
SET B=1;
if b then
select count(*) into flag from Student where Student.StuID = userID and Student.StuPwd = passPwd;
if flag then
SELECT Authority into flag FROM Student where Student.StuID = userID and Student.StuPwd = passPwd;