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不停报错,郁闷啊

Taxonomy upgrade extras:

dbms_output这个函数是干吗用的,mysql里好像没有这个函数。

MySQL中文网: http://imysql.cn
Google MySQL中文用户群:http://groups.google.com/group/imysql

给你的祝福,要让你招架不住!