日期:2014-05-16  浏览次数:20659 次

Truncated incorrect DOUBLE value的错误
mysql> select fid,tid,subject,summary from pre_posts where summary=0 limit 1
;
+-----+-----+--------------------------------------------+----------------------
+
| fid | tid | subject | summary
|
+-----+-----+--------------------------------------------+----------------------
+
| 19 | 34 | 关于假体丰胸手术具体有哪些亮点广州丰胸整型 | 导读:丰胸用什么方法
|
+-----+-----+--------------------------------------------+----------------------
1 row in set, 1 warning (0.00 sec)




mysql> show warnings;
+---------+------+----------------------+
| Level | Code | Message |
+---------+------+----------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: '导读:丰胸用什么方法' |
+---------+------+----------------------+
1 row in set (0.02 sec)



为什么出现这样的情况,很奇怪哦

------解决方案--------------------
summary是varchar(1000)类型
为什么WHERE 中要用summary=0?
------解决方案--------------------
检查你的字符集
------解决方案--------------------
where summary='0'
结果如何