Step 1: After opening Navicat for MySql, right-click on the left side of the mouse and select New Database.
Step 2: Enter the page to create a database. Name the database myxiaoze; fill in utf8 -- UTF-8 Unicode for the character set; fill in utf8_general_ci for the sorting rule. After filling in, click OK:
Related recommendations: "Navicat for mysql usage graphic tutorial"
The third step: in Right-click on the left side to refresh, and you can see the database you just created, as shown below:
Step 4: Double-click to open the database you just created, click on the table, Right-click in the blank space on the right and select New Table, as shown in the figure:
Step 5: Enter the page to create a table. The next step is to create fields, set the primary key and Automatic increment. The function of automatic increment is that every time a piece of data is added, the id will automatically increase without us inputting it.
Step 6: Press Ctrl s at the same time to save the data table, and fill in the data table name, naming it xz. Through the above steps, we can perfectly realize the creation of database and data table.
The above is the detailed content of How to create a table using navicat. For more information, please follow other related articles on the PHP Chinese website!