我有一個帶有自動遞增主鍵的 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.
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.
Does ignore option of Pyspark DataFrameWriter jdbc function ignore entire transaction or just offending rows?(Pyspark DataFrameWriter jdbc 函數的 ignore 選項是忽略整個事務還是只是有問題的行?) - IT屋-程序員軟件開發技
