Help Center > > User Guide> MySQL Database Management (Standard Edition)> SQL Operations> Executing SQL
Updated at: Mar 20, 2020 GMT+08:00
You have logged in to the DAS console.
- On the top menu bar, choose SQL Operation > SQL Window. Select a database from the navigation tree on the left.
- Enter the SQL statements in the SQL window and click Execute SQL.
- If you want to execute multiple SQL statements at a time, separate them using semicolons (;).
- If you want to execute specified SQL statements, select the SQL statements to be executed.
- If you want to execute all SQL statements, do not select any SQL statements or select all SQL statements.
"SELECT * FROM name;"
name indicates the table name.
- View the information about the executed SQL statements on the Executed SQL Statements and view the execution status and duration on the Message tab.
- View the execution results on the Result Sets tab.
- 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.
- 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.