登录页面的MySQL语法错误 [英] MySQL syntax error for login page

问题描述

Create procedure sp_validatelogin(IN email varchar(50), IN ppassword VARCHAR(50))
BEGIN
if exists(Select * From user_details
Where `email`=email
And
`password` = ppassword) THEN
SELECT 1;
else
select 0;
END;

我的错误是

My error is

-[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10.

请有想法的人告诉我.

在此先感谢.

Please someone having some idea then tell me.

Thanks in advance.

推荐答案

尝试一下

Create procedure sp_validatelogin(IN email varchar(50), IN ppassword VARCHAR(50))
BEGIN
if (Select * From user_details Where `email`=email And `password` = ppassword) THEN
  SELECT 1;
else
  select 0;
END;

这篇关于登录页面的MySQL语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！