Help Center > > User Guide> GaussDB (for openGauss) DB Instance Management (Development Tool)> SQL Operations> Executing SQL Statements

Executing SQL Statements

Updated at: Jun 09, 2021 GMT+08:00

Procedure

  1. On the top menu bar, choose SQL Operations > SQL Window. In the SQL window, select a database from the navigation pane.
  2. Enter SQL statements in the SQL window and click Execute SQL.

    • You are advised to enable SQL Input Prompt. It helps you to select your desired database, table, or field name as prompted to quickly enter statements in the SQL window.
    • To execute multiple SQL statements at a time, separate them using semicolons (;). In this case, click Full Screen to view the logics in SQL statements clearly.
      • To execute some of the SQL statements, select the statements before executing them.
      • To execute all the SQL statements, do not select any SQL statements or select all of them.
    Figure 1 Executing SQL statements

  3. View the executed SQL statements and the current execution status in the lower part of the page. On the Messages tab page, view the execution information, including SQL splitting, execution status, and elapsed time.

    Figure 2 Viewing messages

  4. On the Result Sets tab, view the execution details. You can perform the following operations on the result sets:

    • Copy Row/Copy Column: copies a row or column for reuse.
    • Column Settings: customizes the columns to display when there are a large number of columns in the query result.
    • Refresh: refreshes the changed data.
    • Row Details: displays the column field name, value, and type of the selected row.
      Figure 3 Viewing result sets

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel