错误代码:1292.截断了不正确的 DOUBLE 值:“是" [英] Error Code: 1292. Truncated incorrect DOUBLE value: 'yes'
本文介绍了错误代码:1292.截断了不正确的 DOUBLE 值:“是"的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我执行此 SQL 查询时:
When I execute this SQL query:
INSERT INTO archi(nodo1,nodo2)
SELECT p.nodo,p2.nodo
FROM polinodo p,polinodo p2
where p.way=p2.way and p.idpolinodo!=p2.idpolinodo and p.idpolinodo=p2.idpolinodo-1
and p.way in
(SELECT idtag_way
FROM tag_way_min where k='highway' and
idtag_way in (SELECT idtag_way
FROM tag_way_min where k='oneway' and (v=1 or v='true' or v='yes')) )
我收到以下错误:
错误代码:1292.截断了不正确的 DOUBLE 值:'是'
Error Code: 1292. Truncated incorrect DOUBLE value: 'yes'
我该如何解决这个问题?
How can I fix this?
谢谢.
推荐答案
要求从同一行中检索第 k 列的两个不同值似乎存在逻辑问题,
There seems to be a logic problem with asking to retrieve two values for column k from the same row that are different,
(SELECT idtag_way
FROM tag_way_min where k='highway' and
idtag_way in (SELECT idtag_way
FROM tag_way_min where k='oneway' and (v=1 or v='true' or v='yes')
我不明白 k 怎么可以等于两个值.也许改成这样:
I don't see how k can be equal to two values. Perhaps change it to this:
(SELECT idtag_way
FROM tag_way_min where k='highway' or k='oneway'
idtag_way in (SELECT idtag_way
FROM tag_way_min where v=1 or v='true' or v='yes')
这篇关于错误代码:1292.截断了不正确的 DOUBLE 值:“是"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文