MySQL:#1292 - 截断了不正确的 DOUBLE 值:'...' [英] MySQL: #1292 - Truncated incorrect DOUBLE value: '...'

问题描述

我正在尝试创建一个 MySQL 查询来更新所有成员的 PAN 号.

使用下面的查询时，我不断收到此错误，这不是我以前遇到过的，谷歌似乎提供了各种答案，但我无法将修复与我的查询相关联.

UPDATE if_membermaster SET PAN_No = 'ABCD1234D' WHERE 'MemberCode' = 5100

结果:

<块引用>

错误:- #1292 - 截断了不正确的 DOUBLE 值:'MemberCode'

MemberCode 是 int(9) DEFAULT NULL.

有人能帮忙解决这个问题吗?

解决方案

您使用了错误的引号 (PEBCAK).where 子句将 string 'MemberCode' 与 5100 进行比较.这会强制 MySQL 将这两个值都转换为 double，因此出现警告.将单引号改为反引号:

UPDATE if_membermaster SET PAN_No = 'ABCD1234D' WHERE `MemberCode` = 5100

I'm trying to create a MySQL query to update PAN no of all members.

Using the query below I keep getting this error and its not something I've come across before, google seems to offer a variety of answers but I'm unable to relate the fix to my query.

UPDATE if_membermaster SET PAN_No = 'ABCD1234D' WHERE 'MemberCode'  = 5100

Result:

ERROR:- #1292 - Truncated incorrect DOUBLE value: 'MemberCode'

MemberCode is int(9) DEFAULT NULL.

Can any one help to fix this ?

解决方案

You are using wrong quotes (PEBCAK). The where clause is comparing the string 'MemberCode' with 5100. This forces MySQL to convert both values to double hence the warning. Change single quotes to backticks:

UPDATE if_membermaster SET PAN_No = 'ABCD1234D' WHERE `MemberCode` = 5100

这篇关于MySQL:#1292 - 截断了不正确的 DOUBLE 值:'...'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！