Shulou(Shulou.com)05/31 Report--

This article is about how to use "Navicat for MySQL". The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

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 below. If you are using it for the first time, you need to create a connection first.

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 change:

Check:

Thank you for reading! This is the end of the article on "how to use Navicat for MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.