All products

Office Automation

Partners

Intelligent Management

API Center

Backup

Big Data

General Reference

Execute a SQL Statement

You can perform SQL operations on a specific database in the SQL window.

Prerequisites

You have successfully logged in to a database. For more information, see Log in to an RDS MySQL Database or Log in to an RDS PostgreSQL Database.

Usage Guidelines

You can perform SQL operations only on RDS MySQL and RDS PostgreSQL databases.

Procedures

  1. Log in to the DMS Console.
  2. In the left navigation pane, click Quick Database Login to enter the Quick Database Login page.
  3. Click the target login tab, and then enter the domain name, port, database name, database username, and password.
  4. Click Log in Database to enter the Database Management page.
  5. Click the SQL Operation tab, and then select the target database in the right area of the page.
  6. In the SQL execution window, enter a SQL statement. This section uses the RDS MySQL database as an example.
  7. Click Execute.

Result

The Execution Result area displays the execution result of the SQL statement.

Subsequent Procedures

1.  In the Results area, select the target data line, and then click Single line details.

2.  On the Single line details page that opens, view detailed information about the selected data line.

 

Did the above content solve your problem? Yes No
Please complete information！
Ok Cancel

Call us

400-151-8800

Email us

cloud@pingan.com

Online customer service

Instant reply

Consult Now

Technical Support

cloud products

Submitted technical jobs