MySQLUpdate
This system keyword is used for modification operations on MySQL database. It is applicable to statements, such as INSERT, UPDATE, and DELETE, which have no returns.
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
Ip |
Yes |
String |
Database IP address. For a Huawei Cloud RDS instance, you need to bind an EIP to the instance and ensure that the security group policy of the instance port is enabled to allow access. For details, see Connect to a DB 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 UPDATE, which has no returns |
MySQLUpdate Response
|
Parameter |
Type |
Description |
|---|---|---|
|
affected_row_count |
Integer |
Number of rows affected by the SQL statement |
MySQLUpdate Usage Example
Determine the number of affected rows.
MySQLUpdate Response Example
{
"affected_row_count": 3
}
Feedback
Was this page helpful?
Provide feedbackThank 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
