1415 mysql,MySQL Function - Error Code: 1415 Not allowed to return a result set from a function

I am not trying to return a result set and I have no idea what I'm doing wrong here. MySQL 5.5 delimiter $$ CREATE FUNCTION CheckAccount( i_username varchar(50) ) RETURNS integer BEGIN DECLARE v_validUserId int; DECLARE v_validMembership int; DECLARE o_Status integer; SELECT vvalidUserId = u.UserId FROM Users u WHERE u.Username = i_username; IF( v_validUserId IS NULL ) THEN SET o_Status = 2; -- Invalid username ELSE SET o_Status = 1; -- Good END IF; IF(o_Status != 2 ) THEN SELECT v_validMembership = 1 FROM Users u JOIN UserMemberships um on um.UserId = u.userId JOIN Memberships m on m.MembershipId = um.MembershipId WHERE um.MembershipExpireDateTime > CURDATE() AND u.UserId = v_validUserId; IF( v_validMembership IS NULL ) THEN SET o_Status = 3; -- Invalid membership END IF; END IF; RETURN o_status; END $$ DELIMITER ;

Any help will be greatly appreciated!

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值