mysql 创建存储过程或函数常见错误


(1)、ERROR 1418:

# [Err] 1418 - This function has none of DETERMINISTIC,
# NO SQL, or READS SQL DATA in its declaration and binary
# logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

设置下面全局参数:

log-bin-trust-function-creators=1

(2)、ERROR 1064:

[Err] 1064 - 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 '' at line 4

 

增加下面说明:

delimiter //

本站声明
本文转载自:http://dbaspider.iteye.com/blog/2242446     作者:dbaspider     发布日期:2015-09-10     本站转载的文章为个人学习借鉴使用,本站对版权不负任何法律责任。如果侵犯了您的隐私权益,请联系我们删除。


 
© 2014-2016 ITdaan.com 粤ICP备14056181号