title: ON DUPLICATE KEY unrecognized in phpmyadmin
body: <p>I have a mysql database hosted on a remote server, I'm using InnoDB. Everything else works fine but on phpmyadmin whenever I try to execute the following query</p>
  
  <pre><code>INSERT INTO User (user_id, location) VALUES (1, 'London') ON DUPLICATE KEY UPDATE location=VALUES('London')
  </code></pre>
  
  <p>It highlights <code>ON</code>, <code>DUPLICATE</code>, <code>KEY</code> because they're <code>unrecognized keywords</code>
  Help please!</p>