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

This article mainly introduces the method of setting self-increasing navicat, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Open the navicat tool, connect to the mysql server, and after selecting the database, select a table and right-click to select the design table (here, to demonstrate the test, just select a table)

On the design table page, you can see all the field information for 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 to quickly add and cancel the primary key.

After setting the primary key, you can see the identification of a lock, and there is a word 1, because a table can add a primary key to multiple fields, it is a joint 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 the primary key and self-increment, click Save, close the current window, and then select the table name, right-click to select object information.

On the DLL page, you can see the primary key you just added and the self-incremented DLL statement, which is the DLL statement that created the table.

The federated primary key is mentioned above, in fact, a table can set a primary key for multiple fields, which can form a federated primary key, which is also necessary for a specific business.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the content of the self-increasing method of navicat settings. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.