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]