Navicat for MySQL tutorial

First, you need to download and install Navicat for MySQL. It is recommended to support the genuine version. You can also download the cracked version from Baidu.

recommend:

Navicat for MySQL 15 Registration and Activation Detailed Tutorial

Navicat Premium 15 permanent crack activation tool and installation tutorial (professional test available)

Also make sure you have MySQL enabled. (PS: The default port number of MySQL is 3306. It is recommended not to change it)

Next we start using Navicat for MySQL:

Open your navicat, you will see the interface as shown below. If it is the first time to use it, you need to create a connection first.

2. Then we start to create a local database, enter the localhost connection and right click to create a new database

PS:

It is recommended to select UTF-8 for the character set. If there are no Chinese characters in your database, you can select other options. For the sorting rule, just select the first utf8_general_ci.

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

For ideas on designing tables and fields, please see https://www.jb51.net/article/184732.htm
For more information about the data types of the fields, please refer to the official documentation: https://www.runoob.com/mysql/mysql-data-types.html

In addition, you need to use SQL statements to add, delete, modify and query the table. Please see the figure below for adding, deleting, modifying and querying the table in Navicat for MySQL: Add, delete and modify:

check:

This is the basic usage of Navicat for MySQL. If you have anything else to know, please leave a message below.

The above is the detailed content of the detailed tutorial on how to use Navicat for MySQL. For more information about Navicat for MySQL, please pay attention to other related articles on 123WORDPRESS.COM!