3. 在my.ini(linux下为my.conf)文件中 [mysqld] 标记后加一行内容为 log-bin-trust-function-creators如果在create function
以下是引用片段：
errorcode:1418
thisfunctionhasnoneofdeterministic,nosql,orreadssqldatainitsdeclarationandbinaryloggingisenabled(you*might*wanttousethelesssafelog_bin_trust_function_creatorsvariable)
(0mstaken)
解决方法如下：
1. mysql> set global log_bin_trust_function_creators = 1;
2. 系统启动时 --log-bin-trust-function-creators=1
3. 在my.ini(linux下为my.conf)文件中 [mysqld] 标记后加一行内容为 log-bin-trust-function-creators
如果在create function的时候有 1418的错语的时候:那么只需要执行set global log_bin_trust_routine_creators=1;
然后怎么create function 都不会有问题(当然,你的function必段正确哦),这是mysql的一个bug,搞不懂为什么,反正这样做就ok了.
另外，也可以直接在配置文件my.cnf中添加如下行[mysqld] log_bin_trust_routine_creators=1;
这个命令可以在sql editor的环境中运行，并不需要重新启动服务哦。
mysql自5.0之後終於支援sp( store procedures )，
error 1418 (hy000): 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) assessment of the nature of a function is based on the “honesty” of the creator: mysql does not check that a function declared deterministic is free of statements that produce non-deterministic results.
to relax the preceding conditions on function creation (that you must have the super privilege and that a function must be declared deterministic or to not modify data), set the global log_bin_trust_function_creators system variable to 1. by default, this variable has a value of 0, but you can change it like this:
mysql> set global log_bin_trust_function_creators = 1;
you can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.
1. mysql> set global log_bin_trust_function_creators = 1;
2. 系統啟動時，加上--log-bin-trust-function-creators 參數為1
3. 直接在my.ini的[mysqld]區段加上log-bin-trust-function-creators=1
當然我想大多數人會用第三種方法，，
ok...繼續我的sp學習,good luck..
二、mysql error 1418 (hy000)
error 1418 (hy000): 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)
应该是我们开启了bin-log, 我们就必须指定我们的函数是否是
1 deterministic 不确定的
2 no sql 没有sql语句，当然也不会修改数据
3 reads sql data 只是读取数据，当然也不会修改数据
4 modifies sql data 要修改数据
5 contains sql 包含了sql语句
其中在function里面，只有   deterministic, no sql 和   reads sql data 被支持。如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数。
我们可以通过设置如下的参数来关掉这个。
set global log_bin_trust_function_creators = 1;
(you *might* want to use the less safe log_bin_trust_function_creators
variable)