title: MySQL Error 1064 (42000) when running UPDATE query
body: <p>Can anyone tell me what is wrong with this MySQL query?</p>
  
  <p><strong>Query:</strong></p>
  
  <pre><code>UPDATE MATERIAL_MASTER SET MST_NAME='XXX' MAT_DESC='YYY' MAT_TYPE='Raw Material' MAT_GRP='H' UOM='kg' CURRENCY='inr' ENTITY_ASSEMBLED='A' where idMATERIAL_MASTER=3;
  </code></pre>
  
  <p><strong>Error:</strong></p>
  
  <blockquote>
    <p>1064 (42000): You have an error in your SQL syntax; check the manual that
        corresponds to your MySQL server version for the right syntax to use near 'MAT_DESC='YYY' MAT_TYPE='Raw Material' MAT_GRP='H' UOM='kg' CURRENCY='inr' ENTIT' at line 1</p>
  </blockquote>