Help Center> Data Admin Service> User Guide> MySQL DB Instance Management (Standard Edition)> SQL Operations> SQL Execution
View PDF

SQL Execution

Procedure

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

    • To protect query result sets from being displayed as garbled characters caused by UTF-8, the default encoding format, select an encoding format as needed.
    • To execute multiple SQL statements at a time, separate them using semicolons (;).
    • 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 
    "SELECT * FROM name;"

    name indicates a table name.

  3. View the SQL execution details on Executed SQL Statements and Messages tab pages, including the SQL execution history, execution status, impact scope, execution progress, and elapsed time.

    Figure 2 Viewing messages

  4. View the execution results on the Result Sets tab page.

    • If the object has a primary key, you can add, delete, edit, and export data as required.
    • If the object has a primary key, you can update data, view row details, or export data as required.
      Figure 3 Viewing result sets
      • If the result set involves a view, you cannot edit the data.
      • If the type of the result set is metadata, the data cannot be edited or displayed on multiple pages.
      • If the result set involves multiple tables, you cannot edit the data.
      • If the result set involves only one table and does not include all the primary key columns of the table or no primary key is found, you cannot edit the data.
      • Virtual tables (for example, tables generated during SQL execution) cannot be edited.

Parent topic: SQL Operations