Navicat visualization tool for MySQL article

Main content:

　　Introduction and use of NAVICAT tools

　

　1. Introduction and download Installation

<1> Introduction

Navicat is a visual management tool for MySQL database development that operates the MySQL database as a graphical interface. However, it is recommended to use the command line in a production environment to operate the MySQL database.

<2> Download Installation

Official website Download: https://www.navicat.com/en/products/navicat-for-mysql

NET disk Download: HTTPS://PAN.BAIDU.COM/S/1BPO5MQJ

2. Use

<1> test, link database

If after typing, click Test to show "Connection succeeded", the new connection succeeds as shown in:

<2> New Library

　　

　　　　　　

　<3>新建表，新增字段+类型+约束

　　　　

　　　　

　　Note: Remember to save, name the data table, and not be the same as the other table names in the same database.

　　<3> Inserting data

<4> query data

Attention:

Batch Add Comment: Ctrl +? Key batch to comment: Ctrl+shift+? Key

　

<5> backing up the database

　

Navicat visualization tool for MySQL article