通过 表结构 导出 markdone导出postman 参数 导出PHP 类注释

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'