mysql> create procedure check_score4(in id int,out a varchar(50))
-> begin
-> declare result_score varchar(50);
-> declare score float(4,2);
-> select socre into score from student where student.id=id;
-> if score>85 then
-> set result_score =’考的高分’;
-> else
-> set result_score = '考的一般';
-> end if;
-> set @a= result_score;
-> end
-> //
Query OK, 0 rows affected (0.12 sec)
mysql> call check_score4(1,@a)//
ERROR 1054 (42S22): Unknown column '’考的高分’' in 'field list'