mysql创建存储的错误_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 //