MYSQL更新时截断了错误的DOUBLE值 [英] MYSQL Truncated incorrect DOUBLE value while updating

问题描述

这是对mysql数据库的请求.
"UPDATE client_storrage SET LastMatched = UTC_TIMESTAMP()WHERE XUID = 01100000000000"
它给出了错误截断了错误的DOUBLE值:'01100000000000'
XUID varchar(20)utf8_bin
LastMatched datetime
任何人都可以帮助解决此问题吗?

Here is request for mysql database.
"UPDATE client_storrage SET LastMatched=UTC_TIMESTAMP() WHERE XUID=01100000000000"
It gives error Truncated incorrect DOUBLE value: '01100000000000'
XUID varchar(20) utf8_bin
LastMatched datetime
Can any one help to fix this ?

推荐答案

如果XUID是varchar，则必须在查询中使用双引号:

if XUID is a varchar you have to use quotes around it in your query:

UPDATE client_storrage 
SET LastMatched = UTC_TIMESTAMP() 
WHERE XUID = '01100000000000'

这篇关于MYSQL更新时截断了错误的DOUBLE值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！