Help Center/ CodeArts TestPlan/ User Guide/ Configuring a Test Case/ Creating an Automated API Test Case/ System Keywords/ MySQLQuery
Updated on 2026-08-11 GMT+08:00
View PDF
Share

MySQLQuery

This system keyword is used for select operations on MySQL database. A maximum of 100 result records can be queried in the system.

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 query statement

MySQLQuery Response

Status: success

Parameter

Type

Description

[Array elements]

Array of row objects

Structure of the SQL query result list

Parameter Description

Parameter

Type

Description

field1

String

Database field 1

field2

Integer

Database field 2

...

String

Database field n

MySQLQuery Response Example

[
    {
        "name": "Sam",
        "id": "efdb403066474ab08836b9eeaaa23bca",
        "age": 18
    },
    {
        "name": "Sue",
        "id": "g582b0d966611486f918bedb9c711b14",
        "age": 20
    }
]

MySQLQuery Usage Example

  • Query the database table. A user data list is returned based on the system keyword. You can determine the return based on the service.

    Determine the result in the returned list.

  • Query and collect user data. A user data list is returned.

    Determine the result in the response extraction.

Parent topic: System Keywords