Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

cubrid-manager-query-execution


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.

TOOLBAR.PNG

 

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. 

runsql1.png

 

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.  

runsql2.PNG

 

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.   

multiqueries.png

comments powered by Disqus
Page info
viewed 2343 times
translations en
Author
posted last year by
Laura Oh
Contributors
updated last year by
View revisions
tagged
Share this article