Help Center > > User Guide> MySQL DB Instance Management (Standard Edition)> SQL Operations> SQL Execution
Updated at: Sep 29, 2020 GMT+08:00
You have logged in to a MySQL DB instance on the DAS console.
- On the top menu bar, choose SQL Operations > SQL Window. On the displayed page, select a database from the navigation pane.
- 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.
- 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
- 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.