Home  >  Article  >  Database  >  How to create a table using navicat

How to create a table using navicat

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-07 10:18:3836075browse

How to create a table using navicat

Step 1: After opening Navicat for MySql, right-click on the left side of the mouse and select New Database.

How to create a table using navicat

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:

How to create a table using navicat

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:

How to create a table using navicat

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:

How to create a table using navicat

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.

How to create a table using navicat

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.

How to create a table using navicat

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:What does navicat mean?Next article:What does navicat mean?