Mysql 中 存储过程 if else

以下这样写会报错：

[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 'end if' at line 8

1. create procedure test(in a int)
2. if a > 1 then
3. select 1;
4. elseif a>2 then
5. select 2;
6. else
8. end if;

create procedure test(in a int) if a > 1 then select 1; elseif a>2 then select 2; else end if;

应改成以下这样：

1. create procedure test(in a int)
2. if a > 1 then
3. select 1;
4. elseif a>2 then
5. select 2;
6. else
7. -- do nothing --
8. set @tmp=1;
9. end if;