Re: How to return null/empty resultset from SP??

[Ming Yeung]

great thanks, pem!

you gave me a good lesson.
now i do it like this...

CREATE PROCEDURE `adminCheckLogin`(IN inUsername varchar(20), IN inPassword char(32))
BEGIN
DECLARE ret_id INT;
SELECT id INTO ret_id FROM myy_admin WHERE username = inUsername AND password = inPassword;

IF ret_id IS NOT NULL THEN
UPDATE myy_admin SET date_lastlogin = NOW() WHERE id = ret_id;
SELECT ret_id;
ELSE
SELECT 1 FROM DUAL WHERE false;
END IF;
END

^_^