CREATE DEFINER=`root`@`localhost` PROCEDURE `Mobile_ForgotPassword`(IN`v_email` VARCHAR(30), IN `v_valid` INT)
NO SQL
IF (v_valid = 0) THEN
SELECT email FROM user_registration WHERE email = v_email;
ELSE
SELECT password FROM user_registration WHERE email = v_email;
END IF;我有这个MySQL存储过程,它不能工作。每当我试图在phpmyadmin上执行这个脚本时,都会在第4行得到语法错误的错误。由于我使用phpmyadmin,分隔符已经动态添加,并且我对root帐户拥有特权。我试过移除定义器,但它仍然不起作用。据我所知,我没有看到任何语法错误的脚本或我没有得到它。有人吗?
发布于 2015-03-19 06:28:55
CREATE DEFINER=`root`@`localhost` PROCEDURE `Mobile_ForgotPassword`(IN `v_email` VARCHAR(30), IN `v_valid` INT)
NO SQL
IF (v_valid = 0) THEN
SELECT email FROM user_registration WHERE email = v_email LIMIT 1;
ELSE
SELECT password FROM user_registration WHERE email = v_email LIMIT 1;
END IF;发布于 2015-03-19 05:31:52
您需要添加分隔符
DELIMITER |
CREATE PROCEDURE `Mobile_ForgotPassword`(IN`v_email` VARCHAR(30), IN `v_valid` INT)
NO SQL
IF (v_valid = 0) THEN
SELECT email FROM user_registration WHERE email = v_email;
ELSE
SELECT PASSWORD FROM user_registration WHERE email = v_email;
END IF;
|
DELIMITER ;https://stackoverflow.com/questions/29137633
复制相似问题