問題描述
我有一個(gè)帶有自動(dòng)遞增主鍵的 MySQL 表.我刪除了表格中間的一些行.例如,現(xiàn)在我在 ID 列中有這樣的內(nèi)容: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.
我想重新分配/重置/重新排序主鍵,以便保持連續(xù)性,即使 19 變?yōu)?15,使 20 變?yōu)?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.
我該怎么做?
推薦答案
您可以刪除主鍵列并重新創(chuàng)建它.然后應(yīng)按順序重新分配所有 ID.
You could drop the primary key column and re-create it. All the ids should then be reassigned in order.
然而,在大多數(shù)情況下這可能是一個(gè)壞主意.如果您有其他表具有該表的外鍵,那么它肯定不起作用.
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.
這篇關(guān)于重新排序/重置自動(dòng)增量主鍵的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!