为没有自动增长列的表添加自动增长列并更新现有数据

DROP PROCEDURE IF EXISTS `CreateIndex` $$
CREATE  PROCEDURE `CreateIndex`()
BEGIN
  SET @rn=0;
  UPDATE `表名` SET id = (@rn:=@rn+1) ORDER BY '列名' ASC;
  alter table `表名`add PRIMARY KEY (id);
  ALTER TABLE `表名` MODIFY id int(10) unsigned NOT NULL auto_increment;
END $$

刷新页面返回顶部