mysql 同步1064错误及补救方法

mysql slaver服务器上收到这个奇怪的1064错误:

Last_Error: Error '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 '` = 37938' at line 1' on query. Default database: 'database_name'.

从master server传过来的要执行的语句应该是:

update tests set `created_at` = 1195728959, `published_at` = 1195728081 where `id` = 37938;

却变成了上面的样子,在确认此条语句重要性不大后在从服务器上执行以下语句跳过此错误继续同步数据。

mysql> stop slave;mysql> set global sql_slave_skip_counter = 1;mysql> start slave;

按mysql5.1手册上说,在从服务器上没有过直接的数据操作不应该出现这类错误。