摘要： 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 `表名` MO... 阅读全文