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

This article mainly explains the introduction to Navicat, which you may wish to have a look at if you are interested. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the introductory course of Navicat.

1. Connect to the database using 1.1

Open navicat, click the connection, and select the database

Pop up the following interface (take MySQL as an example) and be familiar with the role of each part

To test whether you can connect, if you have the following prompt, click OK to start using the database

Double-click or right-click to open the connection, and the icon highlights to indicate that the connection has been opened

1.2 operate the database

Right-click to connect and click New Database

Enter the database name and encoding rules

Double-click or right-click to open the database (gray icon highlights to open)

Second, import backup

Open the database, right-click to run the SQL file and back up the database file

Select File Import

The successful import is as follows

Close the database, reopen the database, and you can see the table you just imported (compared to the figure above, the table item was originally empty, and there is no arrow on the left)

Third, query data

Query method:

Directly click the corresponding table to query data. Query with sql statement.

Double-click or right-click to open the table to view the data

(the following is a demonstration of querying with SQL statements)

Click ① or ②, and then click New query

Enter sql statement

MySQL statements Please check out another article: statements commonly used in MySQL

4. Modify user information

Log in to mysql and select the database where the user information needs to be modified

Click the user at the top

Select the user name that needs to be modified, and then click above to edit the user

The following screen appears, modify the information you need to modify, and then click Save.

5. Other operations 5.1 View the database version

5.1.1 Terminal View

Open the terminal (shortcut key: Win+r, enter cmd) and enter mysql-V

5.1.2 sql statement View

Enter select version () in the query interface

5.2 View sql execution plan

Use the explain statement to view the analysis results

At this point, I believe you have a deeper understanding of the "introduction to Navicat", you might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow 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.