MySQLDelete
This system keyword is used for deletion operations on MySQL database.
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| Ip | Yes | String | Database IP address. For a Huawei Cloud RDS instance, bind an EIP to the instance and configure its security group rules to allow incoming access. For details, see Using MySQL CLI to Connect to an Instance Through a Public Network. |
| Port | Yes | Integer | Database port |
| DB Name | Yes | String | Database instance name |
| User Name | Yes | String | Username |
| Password | Yes | String | Password (The login password is personal information and must be defined as sensitive in the environment parameters.) |
| Sql | Yes | String | SQL statement, such as DELETE, which has no returns |
MySQLDelete Response
Status: success
| Parameter | Type | Description |
|---|---|---|
| affected_row_count | Integer | Number of rows affected by the SQL statement |
MySQLDelete Response Example
{
"affected_row_count": 1
} MySQLDelete Usage Example
Determine the number of affected rows.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
