title: MySQL INSERT ... SET ... ON DUPLICATE KEY failing... puzzled
body: <p>Can anyone tell me what's wrong with this query:</p>
  
  <pre><code>INSERT `user` 
  SET 
      `password` = SHA1('abc'), 
      `username` = 'admin'
  ON DUPLICATE KEY UPADTE `password` = SHA1('abc')
  </code></pre>
  
  <p>It results in (MySQL 5.6.11):</p>
  
  <blockquote>
    <p>SQL Error (1064): 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 'UPADTE <code>password</code> = SHA1('abc')' at line 5</p>
  </blockquote>
  
  <p>Yet I can't figure out what's wrong with my syntax. From the MySQL manual:</p>
  
  <pre><code>INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
      [INTO] tbl_name
      SET col_name={expr | DEFAULT}, ...
      [ ON DUPLICATE KEY UPDATE
        col_name=expr
          [, col_name=expr] ... ]
  </code></pre>
  
  <p>Source: <a href="http://dev.mysql.com/doc/refman/5.5/en/insert.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/insert.html</a></p>
  
  <p>Thank you!</p>