Preface:
In the daily use of MySQL, we may often use visual tools to connect to MySQL, among which Navicat is the most commonly used. At ordinary times, some students will ask Navicat how to install, how to use and other problems. In this article, I will share a simple tutorial on Navicat operating MySQL based on my personal experience.
1. Introduction of Navicat
Navicat is a mature and reliable database management tool loved by technical people. It is built with an intuitive graphical user interface that allows you to create, organize, access, and share information in a secure and simple way.
Navicat can be used to manage and develop local or remote MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases. It runs on Windows, macOS, and Linux operating systems and provides data transfer, data synchronization, structure synchronization, import, export, backup, restore, report creation tools and plans to assist in data management.
Navicat Premium connects to multiple data sources and Navicat for MySQL for single data sources. But there is not much difference between versions.
2. Easy tutorial sharing
First of all, Navicat is a paid software, here will not explain the installation and crack methods.
Connection management
Select New Connection and fill in the IP address, port number, and account password to create a database connection. If you want to log in with another account, you can click Copy Connect, and the IP port will be filled automatically. You only need to change the account password. Connection management is easy to learn.
Library table operation
Select the corresponding library table, right click to select the corresponding operation, and write SQL effect is similar. But also pay attention to do not misoperate oh, especially click delete must see clearly. Clearing a table means delete from and truncating a table means truncate.
The query window
Query window is often used, select the corresponding library, click new query can open the query window. In the query window we can execute our custom SQL statement, but here also remind, do not put multiple SQL in a query window oh, it is best to select a SQL and then click execute.
When the SQL is longer, you can click to beautify the SQL to make it more readable, and click the Explain button to show the execution plan for the SQL.
Filter table data
When we open a table and find that there is a lot of data in the table, we can click Filter to select the appropriate conditions to screen out the required data. Try this feature when you want to take a break from writing SQL.
Run and dump SQL files
Select the corresponding library and click Run SQL file to select the local file for execution. Select the database or table and click dump SQL file to back up the corresponding database table, or you can choose to back up only the structure. You are advised to back up library tables before operating on them.
Import and export wizard
If you have Excel data that you want to import into a table, or you want to export the data of a table to Excel format, you can select the table, choose import wizard or export wizard, and follow the instructions step by step to complete, but generally suitable for small data volume.
View page Settings
Click the view bar in the upper part of the page to select different display modes. You are advised to select Details so that you can clearly see the information about each table. You can view the statement of creating a table in the right sidebar.
Tool target bar
Click on the upper toolbar for more utilities. Data transfer, data synchronization, and structural synchronization allow you to easily and quickly migrate data at a low cost. Data is also transferred between various database management systems.
Conclusion:
Navicat has many other functions, such as account and authority management, database model design and so on. The above just share some common functions of the author. Tools are only for productivity, but this can only happen if we are familiar with the database and the tools we use. Use it with caution when you encounter unfamiliar features that may cause damage to your database. Use the command line in conjunction with visual tools is also a good choice.