mysql 存储过程if else,使用“if”和“else”存储过程MySQL

Hey guys what's up?? I'm havig some difficulties when trying to create this stored procedure, any kind of help is welcome:

create procedure checando(in nombrecillo varchar(30), in contrilla varchar(30), out resultado int)

begin

if exists (select * from compas where nombre = nombrecillo and contrasenia = contrilla) then

set resultado = 0;

else if exists (select * from compas where nombre = nombrecillo) then

set resultado = -1;

else

set resultado = -2;

end if;

end;

The table I'm working on is:

+-------------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------------+-------------+------+-----+---------+-------+

| Nombre | varchar(30) | YES | | NULL | |

| contrasenia | varchar(30) | YES | | NULL | |

+-------------+-------------+------+-----+---------+-------+

Thank you so much for your time

解决方案

The problem is you either haven't closed your if or you need an elseif:

create procedure checando(

in nombrecillo varchar(30),

in contrilla varchar(30),

out resultado int)

begin

if exists (select * from compas where nombre = nombrecillo and contrasenia = contrilla) then

set resultado = 0;

elseif exists (select * from compas where nombre = nombrecillo) then

set resultado = -1;

else

set resultado = -2;

end if;

end;