SELECT count(*) into @num FROM user_table WHERE (user_name = uName AND user_pass = pPasswd)if @num>1 then select 0; else select 1; end if;
CREATE DEFINER=`root`@`localhost` PROCEDURE `VerifyUser`(uName VARCHAR(20), pPasswd VARCHAR(16), OUT res INT) BEGIN SELECT 1 into res FROM user_table WHERE (user_name = uName AND user_pass = pPasswd); END
select 0;
eles
select 1;
else select 1;
end if;
BEGIN
SELECT 1 into res FROM user_table WHERE (user_name = uName AND user_pass = pPasswd);
END
'截至2012-03-24 00:37:46 用户结帖率0.00% 当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖