Untitled

ON DUPLICATE KEY UPDATE refuses to update

INSERT INTO `Overall` ( `rsn` , `starting_xp` , `starting_lvl` ) VALUES ( 'iWader' , '195843626' , '2281' ) ON DUPLICATE KEY UPDATE `current_xp` = '195843626' AND `current_lvl` = '2281'

       

CREATE TABLE IF NOT EXISTS `overall` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `rsn` varchar(12) NOT NULL,

  `starting_xp` int(10) unsigned NOT NULL,

  `starting_lvl` int(10) unsigned NOT NULL,

  `current_xp` int(10) unsigned NOT NULL,

  `current_lvl` int(10) unsigned NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `rsn` (`rsn`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

       

ON DUPLICATE KEY UPDATE `current_xp` = '195843626', `current_lvl` = '2281'

       

INSERT INTO `Overall` ( `rsn` , `starting_xp` , `starting_lvl` ) VALUES ( 'iWader' , '195843626' , '2281' ) ON DUPLICATE KEY UPDATE `current_xp` = '195843626', `current_lvl` = '2281';