摘要: 一、Mybatis调用存储过程1 在数据库中创建以下的存储过程create or replace procedure pro_hello(p_user_name in varchar2,p_result out varchar2) isbegin p_result := 'hello,' || p_... 阅读全文
posted @ 2015-03-17 17:27 flay 阅读(13190) 评论(2) 推荐(1) 编辑
摘要: MySql创建函数一、查看创建函数的功能是否开启:mysql> show variables like '%func%';+-----------------------------------------+-------+| Variable_name | Value |+------------... 阅读全文
posted @ 2015-03-17 15:26 flay 阅读(771) 评论(0) 推荐(0) 编辑
摘要: 一.在创建存储函数时,出现错误:ERROR 1418 (HY000): This function has none of DETERMINISTIC, NOSQL, or READSSQLDATA in its declaration binary logging is enabled (you ... 阅读全文
posted @ 2015-03-17 14:37 flay 阅读(549) 评论(0) 推荐(0) 编辑