Guest User

Untitled

a guest
Apr 23rd, 2012
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. ON DUPLICATE KEY UPDATE refuses to update
  2. INSERT INTO `Overall` ( `rsn` , `starting_xp` , `starting_lvl` ) VALUES ( 'iWader' , '195843626' , '2281' ) ON DUPLICATE KEY UPDATE `current_xp` = '195843626' AND `current_lvl` = '2281'
  3.  
  4. CREATE TABLE IF NOT EXISTS `overall` (
  5. `id` int(11) NOT NULL AUTO_INCREMENT,
  6. `rsn` varchar(12) NOT NULL,
  7. `starting_xp` int(10) unsigned NOT NULL,
  8. `starting_lvl` int(10) unsigned NOT NULL,
  9. `current_xp` int(10) unsigned NOT NULL,
  10. `current_lvl` int(10) unsigned NOT NULL,
  11. PRIMARY KEY (`id`),
  12. UNIQUE KEY `rsn` (`rsn`)
  13. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  14.  
  15. ON DUPLICATE KEY UPDATE `current_xp` = '195843626', `current_lvl` = '2281'
  16.  
  17. INSERT INTO `Overall` ( `rsn` , `starting_xp` , `starting_lvl` ) VALUES ( 'iWader' , '195843626' , '2281' ) ON DUPLICATE KEY UPDATE `current_xp` = '195843626', `current_lvl` = '2281';
Advertisement
Add Comment
Please, Sign In to add comment