接口调试工具

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

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