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

This article mainly introduces the method of creating tables with 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.

Step 1: after opening Navicat for MySql, right-click on the left and select New Database.

Step 2: go to the page where the database is created. Enter the database name myxiaoze; character set and enter utf8-- UTF-8 Unicode; collation. Enter utf8_general_ci, and then click OK:

Step 3: right-click on the left to refresh, and you can see the database you just created, as shown in the following figure:

Step 4: double-click to open the newly created database, click the table, right-click in the space on the right, and select the new table, as shown in the figure:

Step 5: go to the page to create the table, the next step is to create fields, set the primary key and automatically increment, the role of automatic increment is that each additional piece of data, id will automatically increase, we do not need to enter.

Step 6: at the same time, press Ctrl+s to save the data table, and fill in the data table name, named xz. Through the above steps, we perfect the creation of the database and the creation of the data table.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the method of creating a table with navicat. 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.