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

This article mainly introduces the method of navicat creating a new table, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

Navicat for MySQL is a visual management tool for MySQL databases. Here's a simple example of how to create a table using navicat for mysql.

First, create a database called userdemo.

2. Create a table on the newly created database, as shown in the following figure. The first column of the table is called

userid, set the primary key is not empty, and automatically increased.

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

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

If you open userdemo again, you will see the table you just created. Double-click to open the table and add data to it.

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

In a piece of data, you can enter only the username and password values, but when you Ctrl+s save it will automatically add the userid value, because we set the primary key to increase.

After you add a data save, you will see the statement it inserted as shown in the figure.

Thank you for reading this article carefully. I hope that the article "navicat method of creating a new table" shared by Xiaobian will be helpful to everyone. At the same time, I hope that everyone will support you a lot and pay attention to the industry information channel. More relevant knowledge is 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.