Data Management (DMS) provides the SQLConsole for you to execute SQL statements with ease. You can use this feature to add, delete, modify, or query data in a database in a visualized manner when data query or development is involved.
You have permissions to query the database or table that you want to query. For more information about how to apply for permissions, see Permission management.
- If a table contains sensitive or confidential fields and you do not have permissions
on the fields, the values of the fields are displayed as
******in query results. For more information, see Manage sensitive data.
- By default, a maximum of 200 data rows can be returned for each query. If you are a DMS administrator, you can change this value as needed. Perform the following steps: In the top navigation bar of the DMS console, choose .
- The maximum size of the table on which a full table scan can be performed is 10 GB. If you are a DMS administrator, you can change this value as needed. Perform the following steps: In the top navigation bar of the DMS console, choose .
- By default, the timeout period for executing a single SQL statement is 60 seconds. If you are a DMS administrator, you can change this value in the Advanced information section of the Edit instance dialog box.
- Log on to the DMS console.
- In the top navigation bar, move the pointer over the More icon and choose . Note You can also double-click the database that you want to query In the left-side instance list of the DMS console to go to the SQLConsole tab.
- Select the database that you want to query from the drop-down list or enter a keyword in the field to search for the database. After you select the database, click Confirm.
- Enter the SQL statement to be executed in the field of the SQLConsole tab and click
Table 1. GUI of the SQLConsole No. Section Description 1 Visual operation section In this section, you can manage your database in a visualized manner.
You can view all tables, fields, and indexes of the current database. You can also right-click a table in the database to modify table schema, import data, or export data.
- Programmable objects
You can create, view, execute, and manage programmable objects such as views, stored procedures, functions, triggers, and events.Note A maximum of 1,000 entries can be displayed.
- Key-value pair (KVP) information
Note The KVP information can be displayed only for a NoSQL database.
2 Extended feature section In this section, quick portals to extended features are provided. You can use those features by clicking the following icons:
- : the Tables icon. You can click the icon to view table details. Then, click the icon to return to the SQLConsole tab.
- : the data analysis icon. You can click the icon to create a data analysis ticket. For more information, see Data analysis.
Note The data analysis icon is displayed only for an ApsaraDB RDS for MySQL database.
- : the Database Autonomy Service (DAS) service icon. You can click this icon to make quick diagnosis and conduct real-time performance, instance session, and spatial analyses. After you click this icon, you are navigated to the DAS console. For more information, see Real-time performance and View the session statistics of an ApsaraDB RDS for MySQL instance.
- : the Sync Metadata icon. After you click this icon, DMS collects the latest metadata information of the database, such as tables, fields, indexes, and programmable objects. This helps you manage permissions on tables, fields, and programmable objects based on different security levels. For more information, see Metadata.
- : the export icon. You can click this icon to export the database, table schemas of the database, or table creation statements. You can also click this icon to view the schema versions of this database. For more information about schema versions, see Manage schema versions.
- : the Operation audit icon. You can click this icon to view the information about all query and change
records. For example, you can query the information about a specific operation, the
user who performed the operation, and the time when the operation was performed. For
more information, see Operation audit.
You can also click this icon to use the Risk Audit feature to collect and assess the risks that arise when the database is used. For more information, see Generate a risk audit report.
- : the Share icon. You can click this icon to share the console and commands of the database with relevant staff. For more information, see Share the SQLConsole tab or a ticket.
3 Command running section In this section, you can write and execute SQL statements to manage the data of the current database. You can also use other features in this section, such as Format, Execute Plan, Saved SQL, and Settings.Note You can click the icon to add multiple query tabs. 4 Execution result section In this section, you can view the execution results after SQL statements are executed. You can also view the details of a single row, and add, delete, or modify data.Note You can click the Execution History tab to view historical execution records. For example, you can view the start time of statement execution, database, and executed SQL statements. You can also export the execution results as needed.