Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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';
Advertisement
Add Comment
Please, Sign In to add comment