见:https://zhidao.baidu.com/question/2054378097812574987.html
1.查询表注释
SELECT t.* FROM information_schema.`TABLES` t where t.TABLE_SCHEMA='bsky';
SELECT t.TABLE_NAME,t.CREATE_TIME,t.TABLE_COMMENT FROM information_schema.`TABLES` t where t.TABLE_SCHEMA='bsky';
2.简单描述表结构,字段类型desc tabl_name;
DESC gt_config;
3.查询表字段的注释信息
SELECT t.* FROM information_schema.`COLUMNS` t WHERE TABLE_SCHEMA='bsky' #所在数据库
AND TABLE_NAME='gt_config';#要查询的表名
4.查询表生成的DDL语句
SHOW CREATE TABLE gt_config;