mysql存储过程中的if else 结构

Question

mysql> create procedure check_score1(in id int)
-> begin
-> declare score float(4,2);
-> select socre into score from student where student.id=id;
-> if score>85 then
-> select '考出了高分'；
-> else
-> select '考的一般';
-> end if;
-> end
-> //
ERROR 1064 (42000): 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 'else
select '考的一般';
end if;
end' at line 7

Answer 1

• 给你找了一篇非常好的博客，你可以看看是否有帮助，链接：MySQL 存储过程 if语句