How to use navicat query

#Navicat query function is to extract data from the database according to the user's needs. (Recommended tutorial: navicat tutorial)

Navica provides two powerful tools for working with SQL queries: the query editor can directly edit the query text, and the query creation tool can be visualized Create a query. Users can save queries for setting plans. Click the [Query] button on the Navicat main interface to open the query object list. Or click the [New Query] button in the main window to open the query creation tool or query editor.

Open the query using an external editor. Right-click on the query and select "Open with external editor". You can set the file for the external editor in the options. path.

Warm Tips: The query (.sql) is saved in the set location. To open the folder, right-click on the query and select "Open containing folder". If the connection is synced to Navicat Cloud the query will be saved in the cloud.

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