blocks|key|1369285|text|您可以删除主键列，然后重新创建它。然后，应按顺序重新分配所有in。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369286|然而，在大多数情况下，这可能不是一个好主意。如果您有其他表具有指向此表的外键，那么它肯定不会工作。|1369287|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You could drop the primary key column and re-create it. All the ids should then be reassigned in order.

However this is probably a bad idea in most situations. If you have other tables that have foreign keys to this table then it will definitely not work.

blocks|key|1584542|text|即使这个问题看起来很老了，我也会为那些在这里搜索的人发布一个答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584543|SET+@count+=+0;
UPDATE+`users`+SET+`users`.`id`+=+@count:=+@count+%2B+1;|code-block|syntax|javascript|1584544|如果该列在其他表中用作外键，请确保在这些表中使用ON+UPDATE+CASCADE而不是默认的ON+UPDATE+NO+ACTION作为外键关系。|offset|length|style|CODE|1584545|此外，为了重置AUTO_INCREMENT计数，您可以立即发出以下语句。|1584546|ALTER+TABLE+`users`+AUTO_INCREMENT+=+1;|1584547|对于MySQL，它会将该值重置为MAX(id)+%2B+1。|1584548|entityMap^0|0|0|O|H|1B|J|0|7|E|0|0|G|B|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]|$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@$I|12|J|13|K|L]]|9|@]|A|$]]|$1|O|3|P|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|15|8|@$I|16|J|17|K|L]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|T|$]]

Even though this question seems to be quite old, will post an answer for someone who reaches in here searching.

<pre><code>SET @count = 0;
UPDATE `users` SET `users`.`id` = @count:= @count + 1;
</code></pre>

If the column is used as a foreign key in other tables, make sure you use <code>ON UPDATE CASCADE</code> instead of the default <code>ON UPDATE NO ACTION</code> for the foreign key relationship in those tables.

Further, in order to reset the <code>AUTO_INCREMENT</code> count, you can immediately issue the following statement.

<pre><code>ALTER TABLE `users` AUTO_INCREMENT = 1;
</code></pre>

For MySQLs it will reset the value to <code>MAX(id) + 1</code>.

blocks|key|1369335|text|要重置我的用户表的ID，我使用以下SQL查询。上面已经说过，这将破坏您与任何其他表的任何关系。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369336|ALTER+TABLE+`users`+DROP+`id`;
ALTER+TABLE+`users`+AUTO_INCREMENT+=+1;
ALTER+TABLE+`users`+ADD+`id`+int+UNSIGNED+NOT+NULL+AUTO_INCREMENT+PRIMARY+KEY+FIRST;|code-block|syntax|javascript|1369337|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To reset the IDs of my User table, I use the following SQL query. It's been said above that this will ruin any relationships you may have with any other tables.

<pre><code>ALTER TABLE `users` DROP `id`;
ALTER TABLE `users` AUTO_INCREMENT = 1;
ALTER TABLE `users` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
</code></pre>

blocks|key|1584478|text|您可以简单地使用以下查询|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584479|alter+table+abc+auto_increment+=+1;|code-block|syntax|javascript|1584480|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You may simply use this query

<pre><code>alter table abc auto_increment = 1;
</code></pre>

blocks|key|1584621|text|SET++@num+:=+0;

UPDATE+your_table+SET+id+=+@num+:=+(@num%2B1);

ALTER+TABLE+your_table+AUTO_INCREMENT+=1;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1584622|我想这样就行了。|unstyled|1584623|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre class="lang-sql prettyprint-override"><code>SET @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;
</code></pre>

I think this will do it

blocks|key|1369449|text|或者，从PhpMyAdmin中删除"AutoIncrement“标志，保存，再次设置，然后save.this将其重置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369450|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Or, from PhpMyAdmin, remove "AutoIncrement" flag, save, set it again and save.this resets it.

blocks|key|1370061|text|SELECT+*+from+`user`+ORDER+BY+`user_id`;+

SET+@count+=+0;

UPDATE+`user`++SET+`user_id`+=+@count:=+@count+%2B+1;

ALTER+TABLE+`user_id`+AUTO_INCREMENT+=+1;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1370062|如果你想使用order+by|unstyled|offset|length|style|CODE|1370063|entityMap^0|0|6|8|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>SELECT * from `user` ORDER BY `user_id`; 

SET @count = 0;

UPDATE `user` SET `user_id` = @count:= @count + 1;

ALTER TABLE `user_id` AUTO_INCREMENT = 1;
</code></pre>

if you want to <code>order by</code>

blocks|key|1585201|text|这是有效的-+https://stackoverflow.com/a/5437720/10219008.....but如果你遇到一个问题‘错误代码:+1265.列'id’在行1‘的数据被截断...然后运行以下命令。正在对更新查询添加ignore。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1585202|SET+@count+=+0;
set+sql_mode+=+'STRICT_ALL_TABLES';
UPDATE+IGNORE+web_keyword+SET+id+=+@count+:=+(@count%2B1);|code-block|syntax|javascript|1585203|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/5437720/10219008.....but^0|7|1G|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

This works - <a href="https://stackoverflow.com/a/5437720/10219008.....but">https://stackoverflow.com/a/5437720/10219008.....but</a> if you run into an issue 'Error Code: 1265. Data truncated for column 'id' at row 1'...Then run the following. Adding ignore on the update query.

<pre><code>SET @count = 0;
set sql_mode = 'STRICT_ALL_TABLES';
UPDATE IGNORE web_keyword SET id = @count := (@count+1);
</code></pre>

blocks|key|1369603|text|您可以删除该列的主键自动增量功能，然后每次更新该列时，都会提前运行一个查询，该查询将对表中的所有行进行计数，然后运行一个循环，该循环遍历该行计数，将每个值插入到相应的行中，最后运行一个查询，插入一个新行，其中该列的值是总行计数加1。这将无懈可击，对于试图实现你的目标的人来说，这是最绝对的解决方案。以下是您可以用于该函数的代码示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369604|$table_row_count+=+mysql_result(mysql_query("SELECT+COUNT(`field_1`)+FROM+`table`"),+0);
$viewsrowsdata+=+mysql_query("
++++SELECT+`rank`,+`field1`,+`field2`,+`field3`,+`field4`
++++++++FROM+(SELECT+(@rank:=@rank%2B1)+as+`rank`,+`field1`,+`field2`,+`field3`,+`field4`
++++++++++++FROM+(SELECT+*+FROM+`views`)+a
++++++++++++CROSS+JOIN+(SELECT+@rank:=0)+b
++++++++++++ORDER+BY+rank+ASC)+c
");
while+($row+=+mysql_fetch_assoc($viewsrowsdata))+{
++++$data[]+=+$row;
}
foreach+($data+as+$row)+{
++++$new_field_1+=+(int)$row['rank'];
++++$old_field_1+=+(int)$row['field1'];
++++mysql_query("UPDATE+`table`+SET+`field_1`+=+$new_field_1+WHERE+`field_1`+=+$old_field_1");
}
mysql_query("INSERT+INTO+`table`+(`field1`,+`field2`,+`field3`,+`field4`)+VALUES+('$table_row_count'+%2B+1,+'$field_2_value',+'field_3_value',+'field_4_value')");|code-block|syntax|javascript|1369605|在这里，我创建了一个关联数组，并将其附加到select查询中的rank列中，为每一行提供了从1开始的排名值。然后，我迭代了关联数组。|1369606|另一种选择是获取行数，运行基本的select查询，获取关联数组，并以相同的方式迭代它，但添加了一个变量，该变量在每次迭代中更新。这不太灵活，但可以完成相同的事情。|1369607|$table_row_count+=+mysql_result(mysql_query("SELECT+COUNT(`field_1`)+FROM+`table`"),+0);
$viewsrowsdata+=+mysql_query("SELECT+*+FROM+`table`");
$updated_key+=+0;
while+($row+=+mysql_fetch_assoc($viewsrowsdata))+{
++++$data[]+=+$row;
}
foreach+($data+as+$row)+{
++++$updated_key+=+$updated_key+%2B+1;
++++mysql_query("UPDATE+`table`+SET+`field_1`+=+'$updated_key'+WHERE+`field_1`+=+'$row['field_1']'");
}
mysql_query("INSERT+INTO+`table`+(`field1`,+`field2`,+`field3`,+`field4`)+VALUES+('$table_row_count'+%2B+1,+'$field_2_value',+'field_3_value',+'field_4_value')");|1369608|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You can remove the primary key auto increment functionality of that column, then every time you update that column run a query before hand that will count all the rows in the table, then run a loop that iterates through that row count inserting each value into the respective row, and finally run a query inserting a new row with the value of that column being the total row count plus one. This will work flawlessly and is the most absolute solution to someone trying to accomplish what you are. Here is an example of code you may use for the function:

<pre><code>$table_row_count = mysql_result(mysql_query("SELECT COUNT(`field_1`) FROM `table`"), 0);
$viewsrowsdata = mysql_query("
 SELECT `rank`, `field1`, `field2`, `field3`, `field4`
 FROM (SELECT (@rank:=@rank+1) as `rank`, `field1`, `field2`, `field3`, `field4`
 FROM (SELECT * FROM `views`) a
 CROSS JOIN (SELECT @rank:=0) b
 ORDER BY rank ASC) c
");
while ($row = mysql_fetch_assoc($viewsrowsdata)) {
 $data[] = $row;
}
foreach ($data as $row) {
 $new_field_1 = (int)$row['rank'];
 $old_field_1 = (int)$row['field1'];
 mysql_query("UPDATE `table` SET `field_1` = $new_field_1 WHERE `field_1` = $old_field_1");
}
mysql_query("INSERT INTO `table` (`field1`, `field2`, `field3`, `field4`) VALUES ('$table_row_count' + 1, '$field_2_value', 'field_3_value', 'field_4_value')");
</code></pre>

Here I created an associative array which I had appended on a rank column with the query within a select query, which gave each row a rank value starting with 1. I then iterated through the associative array.

Another option would have been to get the row count, run a basic select query, get the associative array and iterate it through the same way but with an added variable that updates through each iteration. This is less flexible but will accomplish the same thing.

<pre><code>$table_row_count = mysql_result(mysql_query("SELECT COUNT(`field_1`) FROM `table`"), 0);
$viewsrowsdata = mysql_query("SELECT * FROM `table`");
$updated_key = 0;
while ($row = mysql_fetch_assoc($viewsrowsdata)) {
 $data[] = $row;
}
foreach ($data as $row) {
 $updated_key = $updated_key + 1;
 mysql_query("UPDATE `table` SET `field_1` = '$updated_key' WHERE `field_1` = '$row['field_1']'");
}
mysql_query("INSERT INTO `table` (`field1`, `field2`, `field3`, `field4`) VALUES ('$table_row_count' + 1, '$field_2_value', 'field_3_value', 'field_4_value')");
</code></pre>

blocks|key|1584786|text|对于InnoDB，请执行以下操作(这将从表中删除所有记录，首先制作一个面包杯)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584787|SET+@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS+;
SET+@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION+;
SET+NAMES+utf8+;
SET+@OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS,+UNIQUE_CHECKS=0+;
SET+@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,+FOREIGN_KEY_CHECKS=0+;
SET+@OLD_SQL_MODE=@@SQL_MODE,+SQL_MODE='NO_AUTO_VALUE_ON_ZERO'+;
SET+@OLD_SQL_NOTES=@@SQL_NOTES,+SQL_NOTES=0+;
/*+=================================================+*/

drop+table+tablename;
CREATE+TABLE+`tablename`+(
+++table+structure+here!

)+ENGINE=InnoDB+AUTO_INCREMENT=++ai+number+to+reset++DEFAULT+CHARSET=+char+set+here;



/*+=================================================+*/
SET+SQL_MODE=@OLD_SQL_MODE+;
SET+FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS+;
SET+UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS+;
SET+CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT+;
SET+CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS+;
SET+COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION+;
SET+SQL_NOTES=@OLD_SQL_NOTES+;|code-block|syntax|javascript|1584788|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

for InnoDB, do this (this will remove all records from a table, make a bakcup first):

<pre><code>SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS ;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION ;
SET NAMES utf8 ;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 ;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 ;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' ;
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 ;
/* ================================================= */

drop table tablename;
CREATE TABLE `tablename` (
 table structure here!

) ENGINE=InnoDB AUTO_INCREMENT= ai number to reset DEFAULT CHARSET= char set here;



/* ================================================= */
SET SQL_MODE=@OLD_SQL_MODE ;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS ;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS ;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT ;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS ;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION ;
SET SQL_NOTES=@OLD_SQL_NOTES ;
</code></pre>

blocks|key|1369841|text|我也有同样的疑问，但无法对表进行任何更改，在看到我的ID没有超过变量@count中设置的最大数字后，我决定执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369842|SET+@count+=+40000000;
UPDATE+`users`+SET+`users`.`id`+=+@count:=+@count+%2B+1;

SET+@count+=+0;
UPDATE+`users`+SET+`users`.`id`+=+@count:=+@count+%2B+1;

ALTER+TABLE+`users`+AUTO_INCREMENT+=+1;|code-block|syntax|javascript|1369843|解决方案是可行的，但它是安全的，而且是必要的，因为我的表拥有外键，而数据在另一个表中。|1369844|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I had the same doubts, but could not make any changes on the table, I decided doing the following having seen my ID did not exceed the maximum number setted in the variable @count:

<pre><code>SET @count = 40000000;
UPDATE `users` SET `users`.`id` = @count:= @count + 1;

SET @count = 0;
UPDATE `users` SET `users`.`id` = @count:= @count + 1;

ALTER TABLE `users` AUTO_INCREMENT = 1;
</code></pre>

The solution takes, but it's safe and it was necessary because my table owned foreign keys with data in another table.

blocks|key|1369899|text|最好的选择是更改列并删除auto_increment属性。然后发出另一个alter语句，并将auto_increment放回到列中。这会将计数重置为当前行的max%2B1，从而保留对该表的外键引用、数据库中其他表的引用或该列的任何其他键使用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1369900|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The best choice is to alter the column and remove the auto_increment attribute. Then issue another alter statement and put auto_increment back onto the column. This will reset the count to the max+1 of the current rows and thus preserve foreign key references back to this table, from other tables in your database, or any other key usage for that column.

blocks|key|1585156|text|我的意见是创建一个名为row_order的新列。然后对该列重新排序。我不接受对主键的更改。举个例子，如果order列是banner_position，我做了类似这样的事情，这是为了删除，更新，创建banner+position列。调用此函数分别对它们进行重新排序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1585157|public+function+updatePositions(){
++++$offers+=+Offer::select('banner_position')->orderBy('banner_position')->get();
++++$offersCount+=+Offer::max('banner_position');
++++$range+=+range(1,+$offersCount);

++++$existingBannerPositions+=+[];
++++foreach($offers+as+$offer){
++++++++$existingBannerPositions[]+=+$offer->banner_position;
++++}
++++sort($existingBannerPositions);
++++foreach($existingBannerPositions+as+$key+=>+$position){
++++++++$numbersLessThanPosition+=+range(1,$position);
++++++++$freshNumbersLessThanPosition+=+array_diff($numbersLessThanPosition,+$existingBannerPositions);
++++++++if(count($freshNumbersLessThanPosition)>0)+{
++++++++++++$existingBannerPositions[$key]+=+current($freshNumbersLessThanPosition);
++++++++++++Offer::where('banner_position',$position)->update(array('banner_position'=>+current($freshNumbersLessThanPosition)));
++++++++}
++++}
}|code-block|syntax|javascript|1585158|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

My opinion is to create a new column called row_order. then reorder that column. I'm not accepting the changes to the primary key. As an example, if the order column is banner_position, I have done something like this, This is for deleting, updating, creating of banner position column. Call this function reorder them respectively.

<pre><code>public function updatePositions(){
 $offers = Offer::select('banner_position')-&gt;orderBy('banner_position')-&gt;get();
 $offersCount = Offer::max('banner_position');
 $range = range(1, $offersCount);

 $existingBannerPositions = [];
 foreach($offers as $offer){
 $existingBannerPositions[] = $offer-&gt;banner_position;
 }
 sort($existingBannerPositions);
 foreach($existingBannerPositions as $key =&gt; $position){
 $numbersLessThanPosition = range(1,$position);
 $freshNumbersLessThanPosition = array_diff($numbersLessThanPosition, $existingBannerPositions);
 if(count($freshNumbersLessThanPosition)&gt;0) {
 $existingBannerPositions[$key] = current($freshNumbersLessThanPosition);
 Offer::where('banner_position',$position)-&gt;update(array('banner_position'=&gt; current($freshNumbersLessThanPosition)));
 }
 }
}
</code></pre>

blocks|key|1584837|text|您也可以简单地避免使用数字ID作为主键。如果表中包含国家信息，则可以使用国家代码作为主要id，如果表中包含文章，则可以使用固定链接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584838|您也可以简单地使用一个随机数或一个MD5值。所有这些选项都有它自己的好处，特别是在IT+sec上。数字ID很容易枚举。|1584839|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You can also simply avoid using numeric IDs as Primary Key. You could use Country codes as primary id if the table holds countries information, or you could use permalinks, if it hold articles for example.

You could also simply use a random, or an MD5 value. All this options have it's own benefits, specially on IT sec. numeric IDs are easy to enumerate.

I have a MySQL table with an auto increment primary key. I deleted some rows in the middle of the table. Now I have, for example, something like this in the ID column: 12, 13, 14, 19, 20. I deleted the 15, 16, 17 and 18 rows.

I want to reassign / reset / reorder the primary key so that I have continuity, i.e. make the 19 a 15, the 20 a 16, and so on.

How can I do it?

Reorder / reset auto increment primary key

数据库

MySQL

我有一个带有自动增量主键的MySQL表。我删除了表中间的一些行。现在，例如，在ID列中有类似这样的内容: 12，13，14，19，20。我删除了15，16，17和18行。我想重新分配/重置/重新排序主键，以便具有连续性，例如，将19设置为15，将20设置为16，依此类推。我该怎么做呢？

问重新排序/重置自动递增主键
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问重新排序/重置自动递增主键EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问重新排序/重置自动递增主键
EN