title: mysql update ERROR 1054 : Unknown column 'x' in 'field list'
body: <p>I was trying to update mysql table and got ERROR 1054 and after that something strange happen.</p>
  
  <p><strong>Table schema</strong></p>
  
  <pre><code>CREATE TABLE `useraccount` (
    `userId` bigint(20) NOT NULL,
    `currentBalance` float NOT NULL,
    `currentDataBalance` bigint(20) NOT NULL,
    PRIMARY KEY (`userId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>I had one entry in my table i.e.</p>
  
  <pre><code>mysql&gt; select * from UserAccount;
  +--------+----------------+--------------------+
  | userId | currentBalance | currentDataBalance |
  +--------+----------------+--------------------+
  |      1 |              0 |               4296 |
  +--------+----------------+--------------------+
  </code></pre>
  
  <p>I tried to update <code>currentDataBalance</code> field and got the error</p>
  
  <blockquote>
    <p>ERROR 1054 (42S22): Unknown column '253600l' in 'field list'</p>
  </blockquote>
  
  <pre><code>mysql&gt; update UserAccount set currentDataBalance=253600l where userId=1;
  ERROR 1054 (42S22): Unknown column '253600l' in 'field list'
  </code></pre>
  
  <p>Then I removed the last digit of update value <strong>(from 253600l to 253600)</strong> and value got updated</p>
  
  <pre><code>mysql&gt; update UserAccount set currentDataBalance=253600 where userId=1;
  Query OK, 1 row affected (0.01 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  </code></pre>
  
  <p>Then again I changed the value to previous one <strong>(from 253600 to 2536001)</strong> and value got updated this time.</p>
  
  <pre><code>mysql&gt; update UserAccount set currentDataBalance=2536001 where userId=1;
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  </code></pre>
  
  <p>I go through many posts on stackoverflow which are related to error 1054 but I did't get relevant answer.</p>