Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


1. Run a single SQL in the Query Editor

After you created SQLs in the query editor, click a Run(F5) button on the toolbar. Tooltip will be shown when you put mouse-over.



2. Run multiple SQLs in the Query Editor

With Ctrl+a, select all SQLs on the query editor, and then click a Run(F5) button on the toolbar.

Each of SQL should be separated by semi-colon in the end of statement. If your query has a error, then a warning message will be popped up. Queries successfully executed are stored in the SQL history so that you can reuse them by double-clicking in the SQL History tab.

3. Run multiple SQLs Fast in a Run SQL File menu

If you have over hundreds of SQLs to run, it is a lot faster to run thru Run SQL File menu because it doesn't log SQL histories in a local directory.

You can save your queries as a file. On the DB node  with a right mouse click, Run SQL File menu will be shown. You can load your *.sql file to run immediately. 



While running your queries, a progress bar will be shown. If there is any query failed, you can export faild queries and re-run them after modification.  



4. Run Multiple SQLs over Multiple Databases in the Query Editor

You can run queries over multi-hosts or multi-database at the same time in the query editor. You can compare results in a separate window. 

After you create your queries, click the icon(F8) to change to the multiple query mode.  Then you can drag additional DB nodes from the left tree to the Multiple Query Tab.  Once you specify multiple hosts(databases), you can repeat to run another query.   


comments powered by Disqus
문서 정보
viewed 2063 times
번역 en
posted 작년
Laura Oh
마지막 수정시간 작년
변경 내역 보기
Share this article