declare cnt int default 0; select count(*) from user where name=p_name and password=p_password into cnt; if cnt > 0 then else end if;
DELIMITER $$ DROP PROCEDURE IF EXISTS `procCheckLogin` $$ CREATE PROCEDURE `procCheckLogin`(p_name VARCHAR(20),p_password VARCHAR(20)) BEGIN DECLARE iNum INT; SELECT COUNT(*) INTO iNum FROM `User` WHERE ( `name` = p_name ) AND( `password` = p_password ); IF iNum > 0 THEN SELECT 1 AS Result; ELSE SELECT 0 AS Result; END IF; END $$ DELIMITER;
select count(*) from user where name=p_name and password=p_password into cnt;
if cnt > 0 then
else
end if;
DROP PROCEDURE IF EXISTS `procCheckLogin` $$
CREATE PROCEDURE `procCheckLogin`(p_name VARCHAR(20),p_password VARCHAR(20))
BEGIN
DECLARE iNum INT;
SELECT
COUNT(*) INTO iNum
FROM
`User`
WHERE
( `name` = p_name )
AND( `password` = p_password );
IF iNum > 0 THEN
SELECT 1 AS Result;
ELSE
SELECT 0 AS Result;
END IF;
END $$
DELIMITER;