mysql 接收 output,mysql DBMS.output语句咨询

mysql>

create procedure input_college (

v_yxbh int,

v_yxmc varchar(10),

v_lqfsx int,

v_zsrs int,

r int)

begin

select count(*) into r from colleges where id=v_yxbh;

if r>0 then

dbms_output(college have exist!);

else insert into colleges values(v_yxbh,v_yxmc,v_lqfsx,v_zsrs,0); commit; dbms_output(college v_yxmc insert successful!);

end if

exception when others then dbms_output("college "v_yxmc" insert erroe!"); 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 '(college have exist!); else insert into colleges values(v_yxbh,v_yxmc,v_lqfs' at line 1

mysql>

请问dbms_output那里应该怎么写？

写的ORACLE里用的PL／SQL到mysql不停报错，郁闷啊