mysql报错

现象：

131020 10:21:01 [Warning] Statement may not be safe to log in statement format.                                                             Statement: UPDATE `instance` SET `instance_name` = 'Central' WHERE `instance_id`                                                             = '1' LIMIT 1
131020 10:22:01 [Warning] Statement may not be safe to log in statement format.                                                             Statement: UPDATE `instance` SET `instance_name` = 'Central' WHERE `instance_id`                                                             = '1' LIMIT 1

解决方法：

mysql> set global binlog_format=mixed;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

转载于:https://blog.51cto.com/seneagle/1312256