Navicat创建函数,存储过程参考网址:http://blog.csdn.net/peng_hong_fu/article/details/52737402
成功-Navicat拆分字符串:http://blog.csdn.net/u012373815/article/details/52218587
1.CMD直接连接上数据库;然后
CREATE FUNCTION f3(num1 SMALLINT UNSIGNED,num2 SMALLINT UNSIGNED)
RETURNS FLOAT(10,2) UNSIGNED
RETURN (num1+num2)/2;
调用的方法:select f3(1,3);