56,678
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS `wowowo`;
CREATE TABLE `wowowo` (
`guid` bigint(10) NOT NULL,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO`wowowo` (`guid`) VALUES ('1');
INSERT INTO `wowowo` (`guid`) VALUES ('2');
INSERT INTO `wowowo` (`guid`) VALUES ('3');
INSERT INTO `wowowo` (`guid`) VALUES ('4');
INSERT INTO `wowowo` (`guid`) VALUES ('5');
UPDATE `wowowo` SET `guid`=guid+1 order by guid desc;
DROP TABLE IF EXISTS `wowowo`;
CREATE TABLE `wowowo` (
`guid` bigint(10) NOT NULL,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO`wowowo` (`guid`) VALUES ('1');
INSERT INTO `wowowo` (`guid`) VALUES ('2');
INSERT INTO `wowowo` (`guid`) VALUES ('3');
INSERT INTO `wowowo` (`guid`) VALUES ('4');
INSERT INTO `wowowo` (`guid`) VALUES ('5');
ALTER TABLE `wowowo` drop PRIMARY KEY;
UPDATE `wowowo` SET `guid` = `guid` + 1;
ALTER TABLE `wowowo` ADD PRIMARY KEY (`guid`);
SELECT * from `wowowo`;