萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> mysql教程 >> mysql This function has none of DETERMINISTIC

mysql This function has none of DETERMINISTIC

mysql教程 this function has none of deterministic
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)
ysql> show variables like '%func%';
+---------------------------------+-------+
| variable_name                   | value |
+---------------------------------+-------+
| log_bin_trust_function_creators | off   |
+---------------------------------+-------+
1 row in set (0.00 sec)

mysql> set global log_bin_trust_function_creators=1;
query ok, 0 rows affected (0.00 sec)

mysql> show variables like '%func%';
+---------------------------------+-------+
| variable_name                   | value |
+---------------------------------+-------+
| log_bin_trust_function_creators | on    |
+---------------------------------+-------+
1 row in set (0.00 sec)

mysql>

copyright © 萬盛學電腦網 all rights reserved