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'
结果如何
