重新排序/重置自动增量主键

2021-11-20 00:00:00 database mysql

我有一个带有自动递增主键的 MySQL 表.我删除了表格中间的一些行.例如,现在我在 ID 列中有这样的内容:12、13、14、19、20.我删除了 15、16、17 和 18 行.

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.

我想重新分配/重置/重新排序主键,以便保持连续性,即使 19 变为 15,使 20 变为 16,依此类推.

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.

我该怎么做?

推荐答案

您可以删除主键列并重新创建它.然后应按顺序重新分配所有 ID.

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.

相关文章