运行SQL查询-RunSQLQuery

运行用户编辑的SQL查询

Request Parameters

Parameter nameTypeDescriptionRequired
Regionstring地域。 参见 地域和可用区列表Yes
ProjectIdstring项目ID,不填则为默认项目No
DatabaseNamestring数据库名称Yes
QueryStringstringSQL查询语句Yes

Response Elements

Parameter nameTypeDescriptionRequired
RetCodeint操作返回码Yes
Actionstring操作名称Yes
RequeststringAPI请求IDNo
QueryIdstring新建的SQL查询任务的IDNo

Request Example

https://api.ucloud.cn/?Action=RunSQLQuery
&Region=cn-xxx
&DatabaseName=default
&QueryString=SELECT * FROM nation3 LIMIT 10
&ProjectId=jDsRXind

Response Example

{
    "RetCode": 0,
    "Action": "RunSQLQueryResponse",
    "Request": "Qmeoquzn",
    "QueryId": "20180913_082139_00000_22dwf"
}