Button Description. Preview Preview the data of the view. Explain Show the Query Plan of the view. View Builder Build the view visually. It allows you to create and edit views without knowledge of SQL. See SQL Builder for details. Beautify SQL Format the codes with the Beautify SQL settings in Editor. Hint: You can choose to show the preview results below the editor or in a new tab by choosing View -> Result -> Show Below Editor or Show in New Page. When you open a view, View Viewer displays data as a grid. Data can be displayed in two modes: Grid View and Form View. See Data Viewer for details. Procedures / Functions Procedures and functions (stored routines) are supported in MySQL 5.0. A stored routine is a set of SQL statements that can be stored in the server. In the main window, click Function to open the function object list. Click New Function from the object toolbar. Function Wizard will pop up and it allows you to create a procedure/function easily.
Button Description. Untitled text box Enter the name of the snippet that displays in the library and the code completion list. Database Type Choose the database server type of the snippet. Label Choose an existing label or enter a new label name for the snippet. Remarks Enter a description for the snippet that displays in the library. Code Enter the code. Add a placeholder by highlighting any words in the code and click this button. The placeholder will be highlighted in light green. Remove a placeholder by highlighting it in the code and click this button.
Button Description. Open File Open the selected GridFS file. Delete File Delete the selected GridFS files. Upload File Upload files into the bucket. Download File Download the selected GridFS files. Filter Filter the GridFS file table by creating and applying filter criteria. Preview Preview an image file that is less than 1 MB. Progress Check the status of file uploads and downloads. The File table displays all the files that are uploaded to the bucket. You can edit the GridFS file's name, content type, alias or metadata. In the table, right-click the name of the file and select Modify File Name, Modify Content Type, Modify Alias or Modify Metadata. Then, enter the information in the pop-up window.
Button Description. Import Query Import a script file to build the pipeline. Preview All Preview All - Preview the output. Preview All with Reload - Reload the sampled documents and preview the output. Stop Stop the executing pipeline.
Button Description. Preview Preview the data of the view. Explain Show the Query Plan of the view. View Builder Build the view visually. It allows you to create and edit views without knowledge of SQL. See SQL Builder for details. Beautify SQL Format the codes with the Beautify SQL settings in Editor. Hint: You can choose to show the preview results below the editor or in a new tab by choosing View -> Result -> Show Below Editor or Show in New Page. When you open a view, View Viewer displays data as a grid. Data can be displayed in two modes: Grid View and Form View. See Data Viewer for details. Other Objects Navicat also allows you to manage other SQLite objects: Index and Trigger. In the main window, click the corresponding button from the main toolbar to open the object list. Maintain Objects Navicat provides a complete solution for maintaining SQLite objects.
Button Description. Run Run the Map-Reduce job. Stop Stop the running Map-Reduce job. Preview Preview the documents by applying Input, Mapper, Reducer or Finalizer. Import Function Import an existing function to Mapper, Reducer or Finalizer. To run the Map-Reduce job, click Run on the toolbar. If you set to output the results inline, the Result tab opens with the documents returned, the number of documents and the timing information. If you set to write the results to a collection, the results return a document to the specified output collection. GridFS GridFS is a specification for storing and retrieving files. In the main window, click GridFS to open the GridFS object list. You can create multiple buckets in a database for storing files. Click New Bucket and enter the name of the bucket. To open the selected bucket, click Open Bucket. Bucket Viewer files that are inside the bucket.
Button Description. Preview Preview the data of the view. Explain Show the Query Plan of the view. View Builder Build the view visually. It allows you to create and edit views without knowledge of SQL. See SQL Builder for details. Beautify SQL Format the codes with the Beautify SQL settings in Editor. Hint: You can choose to show the preview results below the editor or in a new tab by choosing View -> Result -> Show Below Editor or Show in New Page. When you open a view, View Viewer displays data as a grid. Data can be displayed in two modes: Grid View and Form View. See Data Viewer for details. Materialized Views Materialized Views are schema objects that used to summarize, compute, replicate, and distribute data. In the main window, click Materialized View to open the materialized view object list. You can create a materialized view shortcut by right-clicking a materialized view in the Objects tab and select Create Open Materialized View Shortcut from the pop-up menu. This option is used to provide a convenient way for you to open your materialized view directly without activating the Navicat main window. To refresh a materialized view, right-click it in the Objects tab and select Refresh Materialized View from the pop-up menu. Materialized View Designer is the basic Navicat tool for working with materialized views. You can edit the view definition as SQL statement (SELECT statement it implements) in the Definition tab. To customize the view of the editor and find out more features for SQL editing, see SQL Editor for details. If you want to load SQL statement from a SQL file to the editor, you can choose File -> Import SQL. Preview Preview the data of the materialized view. Explain Show the Query Plan of the materialized view. View Builder Build the materialized view visually. It allows you to create and edit materialized views without knowledge of SQL. See SQL Builder for details. Beautify SQL Format the codes with the Beautify SQL settings in Editor. Hint: You can choose to show the preview results below the editor or in a new tab by choosing View -> Result -> Show Below Editor or Show in New Page. When you open a materialized view, Materialized View Viewer displays data as a grid. Data can be displayed in two modes: Grid View and Form View. See Data Viewer for details. Procedures / Functions Procedures and functions are schema objects that consist a set of SQL statements and stored in the server. In the main window, click Function to open the function object list. Clic...
Button Description. Preview Preview the data of the view. Explain Show the Query Plan of the view. Stop Stop the execution. Procedures / Functions Procedures and functions (stored routines) are supported in MySQL 5.0. A stored routine is a set of SQL statements that can be stored in the server. In the connection tree, click Functions to open the function object list. Button Description Open the function designer to edit the structure. Delete the procedure/function. Create a duplicate copy of the procedure/function.
Button Description. Run Execute the procedure/function. Stop Stop the execution. If the SQL statement is correct, the statement will be executed and, if the statement is supposed to return data, the Result tab opens with the data returned. If an error occurs while executing the procedure/function, execution stops, the appropriate error message is displayed. If the procedure/function requires input parameters, the Input Parameter dialog will pop up. Check the Raw Mode option to pass the inputted values to the procedure/function without quotation marks. Events An event is a task that run according to a schedule. In the connection tree, click Events to open the event object list. Button Description Open the event designer to edit the structure. Delete the event. Create a duplicate copy of the event.
Button Description. Run Run - Execute the entire query. Run Current Statement - Execute the current statement based on the cursor position. Run Selected - Execute the highlighted code. Continue on Error - Ignore errors that are encountered during the execution process. Show Query Profiling and Status - Show the query profiling and status when running the query. Stop Stop the executing query. Explain Show the execution plan of the query: Explain or Explain Selected (when highlighted code). Query Results You can run the query on any server in the project. Select the target connection, database and/or schema from the drop-down list on the toolbar, and then click Run. If the query statement is correct, the query executes and, if the query statement is supposed to return data, the Result tab opens with the data returned by the query. If an error occurs while executing the query, execution stops, the appropriate error message is displayed. The Result tab displays the result data, returned by the query, as a grid. See Data Viewer for details. You are allowed to run selected portion of query, just simply highlight SQL in Query Editor and click Run Selected. To run the current statement your cursor is on (position the cursor within the desired statement), just simply click the down arrow next to Run and select Run Current Statement.
