1导出类注释
SELECT
CONCAT('* @property',' string ',COLUMN_NAME) AS zidian
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='ajy'
AND
table_name = 'sr_case'
效果
2 导出 markdone 文档表格
SELECT
CONCAT(COLUMN_NAME,'|',COLUMN_COMMENT) AS zidian
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='mangguo'
AND
TABLE_NAME = 'sr_copyright'
postman 参数 复制 拷贝到 postman
SELECT
CONCAT(COLUMN_NAME,':',COLUMN_COMMENT) AS zidian
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='mangguo'
AND
table_name = 'sr_task'