CODEWITHSUNDEEP
mysql
Eupheus
Eupheus

Reputation: 73

MySQL: Truncated incorrect DOUBLE value

Trying to execute this below query on MySQL:

update comm_store set flag = 'D' and stores in('EU','AUS','US', 
'CHN') where emp_id in(select emp_id from comm_store_sec)

but getting:

MySQL: Truncated incorrect DOUBLE value 'D'

flag has datatype varchar emp_id has BIGINT

Not betting how to resolve this?

Upvotes: 0

Views: 1639

Answers (1)

jonggu
jonggu

Reputation: 146

What is the flag column data type?

then, change the sql like this

update comm_store set flag = 'D' , stores in('EU','AUS','US', 'CHN') where emp_id in(select emp_id from comm_store_sec)

Just changed the 'and' to ',' I did test on mariadb. succeeded

Upvotes: 1

Related Questions