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;
