Navicat for mysql is a visual management tool for mysql database. Here is a simple example of how to use navicat for mysql to create a table.
Recommended tutorial: MySQL introductory video
1. First create a database, let’s call it userdemo
2. Create a table in the newly created database, as shown below. The first column of the table is called
userid. The primary key is set to not be empty and will be automatically increased.
3. Add a new column to the table by adding a field.
4. After the table data is designed, you can click Save.
5. Expand userdemo and you will see the table you just created. Double-click to open the table and add data to the table.
#6. After adding data, if you want to add or delete a piece of data, click the icon as shown in the picture.
#7. 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 before we The primary key is set to auto-increment.
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 new table in navicat. For more information, please follow other related articles on the PHP Chinese website!