MYSQL中IF嵌套报错
create procedure `test2`(
IN cusername VARCHAR(50),
IN cpassword VARCHAR(50),
IN clastloginio VARCHAR(50)
)
BEGIN
if exists(select * from mt_userlogin where username=cusername) then
-- if exists(select 1) then
if 1=1 THEN
select 1;
ELSE
select 2;
end if;
ELSE
select -7,'Username not found';
end if;
end;只要嵌套一个IF就会报错,网上查了没结果
有人吗,求帮助
页:
[1]