GUI Tools
Query Editor
Preferences
Query History
All queries submitted via the Query Editor will be logged in the History tab on the left sidebar.
Reuse a query from History
To use a query from the history:
- Double click on the query to insert in into the current Query Editor.
- Right click on the query in the History and choose:
Copyto copy the query to the clipboardRunto execute the query in a new tabOpen in anew tabto open Query Editor in a new tab and insert the query into it.Insert to SQL Editorto insert the query into the current Query Editor.
Delete query
To delete a query from History, right click on the query and choose
DeleteTo clear all query history, right click on a query and choose
Clear all historySave to Favorite
To save a query from History to Favorite:
- Right click on the query and choose
Add to favorite - Name the query and assign the bending keyword
- Press
⌘ + Sto save, then close the window.
Find the query location
To see the location of the SQL file that contains query, right click on the query and choose
Show in Finder