MySQL: #1292 - Truncated incorrect DOUBLE value: '...'

Question

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 ?

Are those single quotes around membercode? – P.Salmon Oct 03 '18 at 07:43 — P.Salmon, Oct 03 '18 at 07:43

score 2 · Answer 1 · answered Oct 03 '18 at 07:44

2

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

answered Oct 03 '18 at 07:44

Salman A

262,204
82
430
521

Thank you for saving my time. – Ravindra Kumar Oct 03 '18 at 07:49

MySQL: #1292 - Truncated incorrect DOUBLE value: '...'

1 Answers1

Linked