How to use navicat premium

Navicat is a set of database management tools designed to simplify database management and reduce system management costs. Navicat is built with an intuitive graphical user interface that makes it safe and simple to create, organize, access and share information.

Navicat Premium is a product member of Navicat. It can easily and quickly transfer data between various database systems, or transfer a plain text file with specified SQL format and encoding. Other features include import wizards, export wizards, query creation tools, report creation tools, data synchronization, backup, work planning and more.

This article introduces simple database management in Navicat Premium.

After downloading and installing Navicat Premium, perform the following operations.

Connect to MySQL database

Select Connection > MySQL, set the relevant connection information, and click OK.

Query

Click the query icon>Click New, and then enter the SQL statement, for example:

Related recommendations: "Navicat for mysql graphic tutorial"

View data table

Double-click to connect> ;Double-click the database>Double-click the table:

Or use SQL statement to view:

##*New ( Connection, database, data table, etc.)

The operation is as follows:

* Add data (manually add or use SQL statement)

Import from an existing local file:

Add manually in the interface:

Add with SQL statement: First, right-click the database>Select command line interface...>Enter the add statement

If you want to be proficient in operating any software, it is always indispensable. To use shortcut keys, a few commonly used ones are listed below.

Navicat shortcut key:

The above is the detailed content of How to use navicat premium. For more information, please follow other related articles on the PHP Chinese website!