The method of deleting the self-increasing primary key in mysql

Editor to share with you how to delete the self-adding primary key in mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

The way to delete the self-increasing primary key in mysql: first delete the auto_increment; and then execute the [alter table data Table name drop primary key;] statement to delete the primary key.

Deleting a primary key in MySQL requires the following two steps

(1) if there is an auto_increment, delete it first

(2) Delete the primary key constraint primary key

Alter table T9 modify id int (11); # the modify used here can only change the data type, or you can use change to change the column name while entering a new data type. Alter table T9 drop primary key; # delete primary key after reading this article, I believe you have a certain understanding of the method of deleting the self-increasing primary key in mysql, want to know more about it, welcome to follow the industry information channel, thank you for reading!