Database Workshop
Database Workshop
Database Workshop
Document
What's new
Announcement
Overview
Billing
Permission management
Quick start
Operation guide
Data management
Data interaction platform
Ticket list
Operation and maintenance management
Enterpise security
Approval workflow
Action trail management
User guide (RDS for MySQL)
Instance list
Data management
SQL window
Database management
Ticket list
Data change ticket
SQL review ticket
Clear table tickets
Data cleanup and archiving ticket
Data import and export ticket
Permission application ticket
Operation and maintenance management
Observation and diagnosis
Session management
Monitoring
Enterprise security management
User guide (veDB for MySQL)
Instance List
Data management
SQL window
Database management
Ticket list
Data change ticket
SQL review ticket
Clear table ticket
Data cleanup and archiving ticket
Data import and export ticket
Permission application ticket
Operation and maintenance management
Observation and diagnosis
Session management
Log management
Enterprise security management
User guide (RDS for PostgreSQL)
Instance list
Data management
SQL window
Ticket list
Data change ticket
SQL review ticket
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (RDS for SQL Server)
Instance list
Data management
Ticket management
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (Cache for Redis)
Instance list
Data management
SQL window
Ticket list
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (Document Database for MongoDB)
Instance list
Data management
SQL window
Ticket management
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (External instance user guide)
Developer tools
Best practices
API reference
Compliance Agreement
Instance access
SQL task
Operation and maintenance management
Audit log management
Slow log and optimization suggestions
Diagnostics and Snapshots
SQL insights and auditing
Ticket management
Security control
Appendixes
FAQ
FAQ about permission management
Troubleshooting
- Documentation
Database WorkshopAPI referenceTicket managementCreateDmlSqlChangeTicket
Copy page
Download PDFTicket management
CreateDmlSqlChangeTicket
Copy pageDownload PDFCreateDmlSqlChangeTicket
Call the CreateDmlSqlChangeTicket interface to create a DML data change ticket.
tip
- The DML SQL statements to be executed in this interface cannot exceed 1,000 and must not include DDL SQL statements.
- This is an asynchronous interface. A ticket ID will be returned upon successful creation. Call the DataDescribeTicketDetail interface to query detailed ticket information.
- Pre-checks are required during ticket creation, and the duration depends on the number of SQL statements to be executed.
Request type
Asynchronous request.
Request parameters
Name | Type | Required | Description | Sample |
InstanceType | String | Yes | Database types currently supported are listed below.
| MySQL |
InstanceId | String | Yes | Database instance ID. | mysql-2579f0****** |
SqlText | String | Yes | Pending DML SQL statements. tip
| delete from test_table where id = 1; |
TicketExecuteType | String | Yes | Work order execution type, with the following values:
| Cron |
DatabaseName | String | Yes | Database name for the pending ticket. | db_production |
ExecStartTime | Long | No | Execution start time, using second timestamp format. tip When TicketExecuteType is set to Cron, the execution start time must be specified. | 1692508800 |
ExecEndTime | Long | No | Execution end time, using timestamp format in seconds. tip
| 1692512400 |
Memo | String | No | Ticket remarks. Detailed remarks facilitate future maintenance. | Create a test table for user data storage. |
Title | String | No | Ticket title. | Create test table ticket |
Response parameters
Name | Type | Description | Sample |
TicketId | String | Ticket number | 196490404892248**** |
Request example
POST /?Action=CreateDmlSqlChangeTicket&Version=2018-01-01 HTTP/1.1
Content-Type: application/json
Host: dbw.cn-beijing.volcengineapi.com
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/dbw/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c645****
{
"InstanceType": "MySQL",
"InstanceId": "mysql-2579f0******",
"SqlText": "delete from test_table where id = 1",
"TicketExecuteType": "Cron",
"DatabaseName": "db_production",
"ExecStartTime": 1692508800,
"ExecEndTime": 1692512400,
"Memo": "Create a test table for user data storage.",
"Title": "Create test table ticket"
}
Response example
{
"ResponseMetadata": {
"RequestId": "202405101815074D6C61C22FD7E479870C-e62012",
"Action": "CreateDmlSqlChangeTicket",
"Version": "2018-01-01",
"Service": "dbw",
"Region": "cn-beijing"
},
"Result": {
"TicketId": "196490404892248****"
}
}
Error code
Last updated: 2026.03.13 15:40:09
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
