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

This article mainly explains "what is the basic usage of Navicat Premium". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "what is the basic usage of Navicat Premium"!

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

Navicat Premium is a member of Navicat's product family that enables easy and fast transfer of data between various database systems, or transfer of a plain text file in a specified SQL format and encoding. Other features include import wizard, export wizard, query creation tool, report creation tool, data synchronization, backup, work schedule, and more.

This article describes simple database management in Navicat Premium.

After downloading and installing Navicat Premium, do the following.

Connect to MySQL database

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

query

Click the Query icon> click New, and then enter SQL statements, such as:

view a data table

Double-click Connect> Double-click Database> Double-click Table:

Or use SQL statements to view:

* New (connection, database, data table, etc.)

The operation is as follows:

* Add data (manually or with SQL statements)

Import from existing local files:

Manually add:

Add with SQL statement: first right click database> select command line interface…> input add statement

Want to skillfully operate any software is always inseparable from the use of shortcut keys, listed below a few commonly used.

Navicat Shortcuts:

Ctrl+F Search this page Ctrl+Q Open query window Ctrl+/comment sql statement Ctrl+Shift +/uncomment Ctrl+R Run sql statement in query window Ctrl+Shift+R Run only selected sql statement F6 Open a mysql command line window Ctrl+L Delete a line Ctrl+N Open a new query window Ctrl+W Close a query window Ctrl+D Display data display page Switch to table structure design page, but copy current line when sql is written in query page

environment

At this point, I believe that everyone has a deeper understanding of "what is the basic usage of Navicat Premium", so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

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.