The main features of NAVICAT include SQL creation tools or editors, data Model tools, data transfer, import or export, database or fabric synchronization, reporting, and more. Today we mainly talk about Navicat query function. Its query function is to extract data from the database according to the needs of the user. NAVICAT provides two powerful tools and SQL query work: Query Editor can directly edit the query text, query creation work to visualize the creation of queries. The user can save the query as a setup schedule, and click the "Query" button on the Navicat main interface to open the list of query objects. Or click the new Query button in the main window to open the query creation tool or Query Editor.
Navicat Query button
You can set the file path of the external editor in options by opening the query with an external editor, right-clicking on the query, and selecting Open with external editor.
Warm tip: Query (. sql) is saved in the settings location, to open the folder, right-click on the query and select "Open included folder". If the connection is synchronized to the Navicat cloud, the query is saved in the cloud. About Navicat Cloud, see tutorials: What is Navicat Cloud and frequently asked questions.
Navicat Query function
For more tutorials on Navicat, refer to the Navicat website .
The above is reproduced content, the original is: http://www.formysql.com/wenti/cha-xun.html
Navicat query function How to use