云数据库
  1. 数据库操作
云数据库
  • 数据库操作
    • 执行一条非查询的sql语句
      POST
    • 查询操作(执行查询类型的sql语句)
      POST
  • 管理者操作
    • 查询数据库信息
      POST
    • 添加数据库
      POST
  • 初始化token
    POST
  1. 数据库操作

查询操作(执行查询类型的sql语句)

开发中
POST
/querySqlExecute

请求参数

Body 参数application/json
token
string 
必需
databaseName
string 
必需
tableName
string 
必需
sql
object 
必需
data
object 
必需
示例
{
    "token": "string",
    "databaseName": "string",
    "tableName": "string",
    "sql": {},
    "data": {}
}

示例代码

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST '/querySqlExecute' \
--header 'Content-Type: application/json' \
--data-raw '{
    "token": "string",
    "databaseName": "string",
    "tableName": "string",
    "sql": {},
    "data": {}
}'

返回响应

🟢200成功
application/json
Body
result
integer 
必需
return
array[string]
必需
reason
string 
必需
tips
null 
必需
示例
{
    "result": 200,
    "return": [
        [
            [
                "1,"
            ],
            [
                "12,"
            ],
            [
                "25,"
            ],
            [
                "1"
            ],
            [
                "12"
            ],
            [
                "25"
            ],
            [
                "1"
            ],
            [
                "12"
            ],
            [
                "25"
            ]
        ],
        [
            [
                "1,"
            ],
            [
                "12,"
            ],
            [
                "25,"
            ],
            [
                "1"
            ],
            [
                "12"
            ],
            [
                "25"
            ],
            [
                "1"
            ],
            [
                "12"
            ],
            [
                "25"
            ]
        ],
        [
            [
                "1,"
            ],
            [
                "12,"
            ],
            [
                "25,"
            ],
            [
                "1"
            ],
            [
                "12"
            ],
            [
                "25"
            ],
            [
                "1"
            ],
            [
                "12"
            ],
            [
                "25"
            ]
        ]
    ],
    "reason": "合法请求,查询语句成功。",
    "tips": null
}
修改于 2022-07-19 03:38:55
上一页
执行一条非查询的sql语句
下一页
查询数据库信息
Built with