mysql> update *** set ctime='2000-01-01 00:00:00' where s_id=936;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: '45_72'
中有答案：
This message means you're trying to compare a number and a string in a WHERE or ON clause
sid是varchar类型，类型不匹配，就报错了
阅读(783) | 评论(0) | 转发(0) |
