When developing a website, you often need to use a database to save data. How do we create a database and create a data table? The method is actually very simple. The editor will teach you how to use Navicat for MySql to create a database and data table operation process.

Tools/Materials

Computer

Navicat Database Management Tool

Method/Steps

1. First Step: Create a database locally. First, start the database running environment. Both Apache and MySQL will display green, indicating that the environment is successfully started. Otherwise, the database cannot be operated if the environment fails to be started.

2. Step 2: Open the database management tool Navicat for MySql, which is used to manage the creation, management and other operations of our database, as shown in the figure below:

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

4. Step 4: Enter the page to create a database. Name the database myxiaoze; fill in the character set as utf8--UTF- 8Unicode; fill in utf8_general_ci for the sorting rule, and click OK after filling in:

5. Step 5: Right-click refresh on the left side, and you can see the database you just created, as shown in the figure below:

6. Step 6: Double-click to open the database you just created, click on the table, right-click on the blank space on the right, and select New Table, as shown in the figure:

7. Step 7: Enter On the table creation page, the next step is to create fields, set the primary key and auto-increment. The function of auto-increment is that every time a piece of data is added, the id will automatically increase without us inputting it.

8. Step 8: Press Ctrl+s at the same time to save the data table, and fill in the data table name and name it xz. Through the above steps, we can perfectly realize the creation of database and data table.