1、列出数据表及表状态信息
SHOW TABLE STATUS [FROM db_name]
2、列出字段及详情
SHOW FULL COLUMNS FROM tbl_name [FROM db_name]
3、列出表索引信息：
SHOW INDEX FROM tbl_name [FROM db_name]
1、列出数据表及表状态信息
SHOW TABLE STATUS [FROM db_name]
2、列出字段及详情
SHOW FULL COLUMNS FROM tbl_name [FROM db_name]
3、列出表索引信息：
SHOW INDEX FROM tbl_name [FROM db_name]