創(chuàng)建函數(shù)時(shí)問題馬上出現(xiàn):

ERROR 1418 (HY000): This routine 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_routine_creators

variable)

在mysql在線文檔中找到解決方案，網(wǎng)址為:

http://dev.mysql.com/doc/refman/5.1/zh/stored-procedures.html#create-procedure

只需要將log_bin_trust_routine_creators 設(shè)置為 1 即可，解決方法

在my.ini的[mysqld]下加上log-bin-trust-function-creators=1

希望各位在使用過程中碰到問題少走彎路。