将表定义转为markdown格式的语句

mysql

发布日期: 2022-07-18

更新日期: 2022-07-18

文章字数: 60

阅读时长: 1 分

阅读次数:

将表定义一个转为markdown格式的语句

SELECT CONCAT("## ",table_name," ",table_comment) as tabel_details 
FROM information_schema.TABLES
WHERE TABLE_schema='A'
and table_name ='B'

UNION ALL 

SELECT "|字段 | 类型 | 描述|" as tabel_details 

UNION ALL 
 
SELECT "|---- |---- |----|"  as tabel_details

UNION ALL 

SELECT concat("|",COLUMN_NAME,"|",COLUMN_TYPE,"|",COLUMN_COMMENT,"||") 
from information_schema.COLUMNS
WHERE TABLE_schema='A'
    and table_name ='B'
;