用Mysql Workbench进行mysql函数编写时,总是错误,报错信息说时语法错误,但是别人用navicat就可以运行,查了好久知道要重置结束符来解决这个问题
一般这样就可以运行:
create function get_choose_number_fn(sno char(20))
returns int
reads sql data
begin
declare rs int;
select count(*) into rs
From choose
where student_no=sno;
return rs;
end;
但是mysqlworkbench要这样:
delimiter $$
create function get_choose_number_fn(sno char(20))
returns int
reads sql data
begin
declare rs int;
select count(*) into rs
From choose
where student_no=sno;
return rs;
end;
$$
delimiter ;