Help Center/ Data Admin Service/ API Reference/ APIs (in OBT)/ Cloud DBA/ Deleting a Concurrency Control Rule of SQL Statements

Updated on 2024-08-05 GMT+08:00

View PDF

Deleting a Concurrency Control Rule of SQL Statements

Function

This API is used to delete concurrency control rules of SQL statements. Currently, this function is supported only for MySQL databases.

URI

DELETE /v3/{project_id}/instances/{instance_id}/sql-limit/rules

**Table 1** Path parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. To obtain this value, see Obtaining a Project ID.
instance_id	Yes	String	Instance ID.

Request Parameters

**Table 2** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	User token.
X-Language	No	String	Language. The value can be: zh-cn en-us

**Table 3** Request body parameters
Parameter	Mandatory	Type	Description
datastore_type	Yes	String	Database type. The value can be: MySQL
sql_limit_rule_ids	Yes	Array of strings	ID of a concurrency control rule of SQL statements.
database_name	No	String	Database name.

Response Parameters

Status code: 400

**Table 4** Response body parameters
Parameter	Type	Description
error_code	String	Error code. Minimum length: 8 Maximum length: 36
error_msg	String	Error message. Minimum length: 2 Maximum length: 512

Status code: 500

**Table 5** Response body parameters
Parameter	Type	Description
error_code	String	Error code. Minimum length: 8 Maximum length: 36
error_msg	String	Error message. Minimum length: 2 Maximum length: 512

Example Requests

Deleting concurrency control rules of SQL statements

DELETE https://das.cn-north-1.myhuaweicloud.com/v3/054c630ff780d4cc2f40c00d7f6fb21d/instances/d871e13ee1044e21a473330cd67047cbin01/sql-limit/rules

{
  "datastore_type" : "MySQL",
  "sql_limit_rule_ids" : [ "6", "7" ]
}