Auto increment index 재정렬

SET @o:= (SELECT COUNT(*) FROM {tableName}) + 10;
SET @n:= @o;
UPDATE {tableName} SET {indexName} = @n:=@n+1 ORDER BY `{fieldName}` ASC;
UPDATE {tableName} SET {indexName} = {indexName} - @o;
ALTER TABLE {tableName} AUTO_INCREMENT=0;