get_table_data
Retrieve data from a MySQL table by specifying table, columns, filters, sorting, and pagination without writing raw SQL.
Instructions
快速获取表数据(封装 SELECT,避免手写 SQL)。
Parameters: table: 表名 columns: 列名,如 'id,name,email',默认 '*' where: WHERE 条件(不含 WHERE 关键字),如 'id > 10 AND status = 1' order_by: 排序,如 'id DESC' limit: 返回行数(≤1000) offset: 偏移量
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| table | Yes | ||
| where | No | ||
| offset | No | ||
| columns | No | * | |
| database | No | ||
| order_by | No |