title: MySQL: Truncated incorrect DOUBLE value
body: <p>Trying to execute this below query on MySQL:</p>
  
  <pre><code>update comm_store set flag = 'D' and stores in('EU','AUS','US', 
  'CHN') where emp_id in(select emp_id from comm_store_sec) 
  </code></pre>
  
  <p>but getting:</p>
  
  <p>MySQL: Truncated incorrect DOUBLE value 'D'</p>
  
  <p>flag has datatype varchar
  emp_id has BIGINT</p>
  
  <p>Not betting how to resolve this? </p>