title: MySQL INSERT ... ON DUPLICATE KEY not updating table with no errors or warnings
body: <p>So I have the following table:</p>
  
  <pre><code>mysql&gt; show create table user_api_skills \G
  *************************** 1. row ***************************
         Table: user_api_skills
  Create Table: CREATE TABLE `user_api_skills` (
    `characterID` int(11) NOT NULL,
    `typeID` int(11) NOT NULL,
    `level` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
    `skillpoints` int(11) NOT NULL,
    `currentTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`characterID`,`typeID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  1 row in set (0.00 sec)
  
  mysql&gt;
  </code></pre>
  
  <p>And in that table a row which I am trying to insert/update:</p>
  
  <pre><code>mysql&gt; SELECT * FROM `user_api_skills` WHERE `characterID` =93192782 AND `typeID` =3359;
  +-------------+--------+-------+-------------+---------------------+
  | characterID | typeID | level | skillpoints | currentTime         |
  +-------------+--------+-------+-------------+---------------------+
  |    93192782 |   3359 | 3     |      135765 | 2013-09-30 16:58:35 |
  +-------------+--------+-------+-------------+---------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>I believe my query is correctly formed and when executed it doesn't throw any errors or warnings:    </p>
  
  <pre><code>mysql&gt; INSERT INTO user_api_skills (characterID,typeID,level,skillpoints)
  VALUES (93192782,3359,4,135765) ON DUPLICATE KEY UPDATE level=4,             
  skillpoints=135765,currentTime=NOW();
  Query OK, 2 rows affected (0.22 sec)
  </code></pre>
  
  <p>I get 2 rows updated (as I would expect from an insert on dup update)</p>
  
  <pre><code>mysql&gt; SELECT * FROM `user_api_skills` WHERE `characterID` =93192782 AND `typeID` =3359;
  +-------------+--------+-------+-------------+---------------------+
  | characterID | typeID | level | skillpoints | currentTime         |
  +-------------+--------+-------+-------------+---------------------+
  |    93192782 |   3359 | 3     |      135765 | 2013-09-30 16:59:13 |
  +-------------+--------+-------+-------------+---------------------+
  1 row in set (0.00 sec)
  
  mysql&gt; 
  </code></pre>
  
  <p>but the row itself only changes a single value (the currentTime). Can anybody explain why the other two fields are not updating? </p>