接口调试工具

Apipost

https://www.apipost.cn/

参数描述库内容添加

SELECT 
    distinct COLUMN_NAME, 
    table_name, 
    DATA_TYPE, 
    COLUMN_COMMENT, 
    CONCAT(COLUMN_NAME,':',COLUMN_COMMENT) as '参数描述库'
FROM 
    information_schema.COLUMNS 
WHERE 
    table_schema = 'DBNAME' and COLUMN_COMMENT != '' 
    group by COLUMN_NAME 
    ORDER BY COLUMN_NAME

查询处参数描述库,导入到参数描述库中.

文档自动用参数库填充

Apifox

将数据库备注导入apifox常用参数

SELECT 
    distinct COLUMN_NAME, 
    table_name, 
    DATA_TYPE, 
    COLUMN_COMMENT, 
    CONCAT(COLUMN_NAME,',',COLUMN_COMMENT) as 'apifox常用参数'
FROM 
    information_schema.COLUMNS 
WHERE 
    table_schema = 'DBNAME' and COLUMN_COMMENT != '' 
    group by COLUMN_NAME 
    ORDER BY COLUMN_NAME

将apifox常用参数导入到apifox设置中的常用参数。

在修改文档中使用时，选择返回响应，点击通过json生成。注释写入，选择中文即可。