Truncated incorrect DOUBLE value

By gavin

mysql报错Truncated incorrect <span class="hljs-keyword">DOUBLE</span> <span class="hljs-keyword">value</span>

参考 https://stackoverflow.com/questions/16068993/error-code-1292-truncated-incorrect-double-value-mysql

主要原因是查询语句包含类型不匹配的对比,例如一个varchar类型字段与数值比较