Re: If Then Else is not working

[Peter Brawley]

Read the manual chapters on sprocs again, and notice the bits about begin & end, and the bits about defining a delimiter ...

drop procedure if exists sptest();
delimiter go
create procedure sptest()
begin
  IF (1=1) THEN
    select 1;
  ELSE
    select 2;
  END IF;
end;
go
delimiter ;
call sptest();
+---+
| 1 |
+---+
| 1 |
+---+