The method of setting the self-increasing primary key in navicat

Editor to share with you the method of setting the primary key of navicat self-increasing, I hope you will gain something after reading this article, let's discuss it together!

After the mysql database creates a table, in order to identify a record, there is usually a unique id. This id can be set as a primary key and self-incrementing mode, so that when a new record is inserted, it will automatically increment with the previous id. Setting primary keys and self-increment for tables can be done either through sql or graphically using the tool navicat.

1. 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)

2. 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.

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

4. 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, etc.

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

After reading this article, I believe you have a certain understanding of "the method of self-increasing primary keys in navicat". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!