Data Admin Service
Data Admin Service
- What's New
- Function Overview
- Service Overview
- Getting Started
-
User Guide
- Overview
- Permissions Management
- Logging In to the DAS Console
- Adding Login Information
- Logging In to a Database
- Modifying Login Information
- Deleting Login Information
- Logging In to Databases Shared by Others
- MySQL DB Instance Management (Development Tool)
- RDS for PostgreSQL Instance Management (Development Tool)
- DDS DB Instance Management (Development Tool)
- Distributed DDM DB Instance Management (Development Tool)
- Intelligent O&M
- Audit
- Change History
- Best Practices
-
FAQs
- Product Consulting
-
Connection Management (Development Tool)
- What Should I Do If I Can't Connect to My DB Instance Due to Insufficient Permissions?
- What Should I Do If I Can't Connect to My RDS for MySQL Instance?
- What Should I Do If I Can't Connect to My ECS (MySQL) Instance?
- What Should I Do If I Can't Connect to My RDS for PostgreSQL Instance?
- What Should I Do If I Can't Connect to My ECS (PostgreSQL) Instance?
- What Should I Do If I Can't Connect to My DDS Instance?
- What Should I Do If I Can't Connect to My DDM Instance?
- How Do I View and Modify ECS Security Group Rules?
- How Do I View and Modify Firewall Rules?
- Usage
- Service Support
- Change History
- Videos
On this page
Show all
Help Center/
Data Admin Service/
User Guide/
DDS DB Instance Management (Development Tool)/
Command Operation/
Command Window
Command Window
Updated on 2023-03-07 GMT+08:00
Procedure
- On the top menu bar, choose Command Operation > Command Window.
- In the displayed text box, enter the commands you want to execute and click Execute Command.
- In the lower part of the page, view the execution results.
- On the Executed Commands tab page, view the details about the commands that have been executed.
- On the Messages tab page, view the execution results (successful or failed) and execution duration of current commands.
NOTE:
- Currently, the db.collection.aggregate() command is not supported. You can run the db.runCommand command instead. The following is an example about how to use syntax:
db.runCommand({ aggregate: "collection", pipeline: [{ "$match": { "time": { "$gte": 20.0 } } }, { "$sort": { "time": -1.0 } } ] });
- You can execute SQL commands in either of the following ways:
- Append Mode: Each time a command is executed, the new result set is appended to the previous one.
- Overwrite Mode: Each time a command is executed, the new result set overwrites the previous one.
Parent topic: Command Operation
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.