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

Editor to share with you how to use navicat to add primary keys and self-increment to database tables. I hope you will gain a lot after reading this article. Let's discuss it together.

Setting primary keys and self-increments for tables can be done either through sql or graphically using the tool navicat.

Open the navicat tool and connect to the mysql server. After selecting the database, select a table and right-click to select [Design Table].

On the design table page, you can see all the field information of the current table. The student table we selected has an id field, which currently has no primary key field.

As shown in the figure, right-click to select the primary key in the last column, you can set the field as the primary key, or you can click the left mouse button directly to quickly add and cancel the primary key.

After setting the primary key, you can see the identification of a lock and have a word 1, because a table can add a primary key to multiple fields, it is a federated primary key, so it is displayed as primary key 1, primary key 2, and so on.

After the primary key is set, it has not been self-incremented. After selecting the id field, check the auto-increment box below, as shown in the figure, so that id will increment a value each time the record is inserted.

After setting up the primary key and self-adding, click Save to close the current window.

After reading this article, I believe you have a certain understanding of how to use navicat to add primary keys to database tables. If you want to know more about it, you are welcome to follow the industry information channel. Thank you for your 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.