The use of Navicat for MySQL

First of all, to download and install Navicat for MySQL, it is recommended to support genuine version, you can also download the cracked version on Baidu can also be used.

And make sure you turn on your MySQL. (the default port number for PS:MySQL is 3306. It is recommended not to change)

Next let's start using Navicat for MySQL:

Open your navicat and you will see the interface shown in the following figure

If it is the first time to use it, you need to create a connection first.

Zhengzhou Infertility Hospital: http://www.zzchbb.com/

two。 Then we start to create a local database, go to the localhost connection and right-click to create a new database

PS:

Character set is recommended to choose UTF-8, if you do not store Chinese characters in the database, you can choose other options

Just choose the first utf8_general_ci for the collation.

Now let's create the tables and fields in the database

For ideas on designing tables and fields, see https://blog.csdn.net/weixin_43606158/article/details/91129489.

For the data type of the field, please see the official document: https://www.runoob.com/mysql/mysql-data-types.html

In others, we will start to use SQL statements to add, delete, change and query the table. For the addition, deletion, change and query of the table in Navicat for MySQL, please see the following figure:

Add, delete and modify:

Check:

This is the end of the basic use of Navicat for MySQL. If there is anything else you need to know, please feel free to leave a message below.