How to create a table in navicat

First create a database and name it userdemo.

Related recommendations: "Navicat for mysql usage graphic tutorial"

Newly created Create a table on the database, as shown below. The first column of the table is called userid. The primary key is set to not be empty and is automatically increased.

Add a new column to the table by adding a field.

After the table data is designed, you can click Save.

Expand userdemo and you will see the table you just created. Double-click to open the table and add data to the table.

After adding data, if you want to add or delete a piece of data, click the icon as shown in the picture.

In a piece of data, you can only enter the values ​​​​of username and password, but when you Ctrl s to save it will automatically add the value of userid, because we set it before The primary key is automatically incremented. After you add a piece of data to save, as shown in the figure, you will see the statement it inserted.

The above is the detailed content of How to create a table in navicat. For more information, please follow other related articles on the PHP Chinese website!