开发笔记:mysql新建存储过程中容易出错的地方

DELIMITER $$
USE `tongliaograin`$$
DROP PROCEDURE IF EXISTS `A_Sys_GetAdminValidate`$$
CREATE DEFINER=`root`@`%` PROCEDURE `A_Sys_GetAdminValidate`(IN `sLoginName` VARCHAR(100),IN `sPassword` VARCHAR(100),IN `sIP` VARCHAR(100))
BEGIN
DECLARE nNum INT DEFAULT 0;
DECLARE nAdminID INT DEFAULT 0;
DECLARE slogcontent VARCHAR(100) DEFAULT "";
SELECT * FROM sys_admin WHERE LoginName = sLoginName AND `password`=sPassword;
SELECT COUNT(*) INTO nNum FROM sys_admin WHERE LoginName = sLoginName AND `password`=sPassword;
IF(nNum > 0) THEN
SELECT CAST(AdminID AS SIGNED) INTO nAdminID FROM sys_admin WHERE LoginName = sLoginName AND `password`=sPassword;
SET slogcontent = CONCAT(‘【用户登录】后台用户:‘,sLoginName,‘IP地址为：‘,sIP,‘ 登录成功‘);
CALL A_SysLog_Add(12,nAdminID,slogcontent);
END IF;
END$$
DELIMITER ;