Tag: Alter auto-increment primary key

If you accidentally lose the primary key and need to modify the id column of the table as the primary key, you can use the following SQL statement