mysql查询各种对象

 1   SHOW   DATABASES   [LIKE   wild]  
 2   or   SHOW   [OPEN]   TABLES   [FROM   db_name]   [LIKE   wild]  
 3   or   SHOW   [FULL]   COLUMNS   FROM   tbl_name   [FROM   db_name]   [LIKE   wild]  
 4   or   SHOW   INDEX   FROM   tbl_name   [FROM   db_name]  
 5   or   SHOW   TABLE   STATUS   [FROM   db_name]   [LIKE   wild]  
 6   or   SHOW   STATUS   [LIKE   wild]  
 7   or   SHOW   VARIABLES   [LIKE   wild]  
 8   or   SHOW   LOGS  
 9   or   SHOW   [FULL]   PROCESSLIST  
10   or   SHOW   GRANTS   FOR   user  
11   or   SHOW   CREATE   TABLE   table_name  
12   or   SHOW   MASTER   STATUS  
13   or   SHOW   MASTER   LOGS  
14   or   SHOW   SLAVE   STATUS  
15   or   SHOW   WARNINGS   [LIMIT   #]  
16   or   SHOW   ERRORS   [LIMIT   #]  
17   or   SHOW   TABLE   TYPES  
18   SHOW   provides   information