Help Center> CloudTest> User Guide> Test Case> Advanced Configurations of API Automation> System Keywords> Database - MySQLUpdate
Updated on 2023-03-14 GMT+08:00
View PDF

Database - 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 Connecting to a DB Instance Using a MySQL Client.

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

Status: success

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
}
Parent topic: System Keywords