Shulou(Shulou.com)06/01 Report--

Editor to share with you how mysql removes primary key constraints. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql removes the primary key constraint by first executing the [Alter table tb change id id int (10);] command to delete self-growth, and then executing the [Alter table tb drop primary key;] command to delete the primary key.

First delete self-growth

Alter table tb change id id int (10); / / delete self-growth

Then delete the primary key

Alter table tb drop primary key;// delete the main construction finished reading this article, I believe you have a certain understanding of mysql to remove primary key constraints, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.