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]
4、列出某用户权限:
SHOW GRANTS FOR user
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]
4、列出某用户权限:
SHOW GRANTS FOR user