Apipost
参数描述库内容添加
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生成。注释写入，选择中文即可。
