难show databases问题

Question

怎样才能像phpMyAdmin里显示出  
   数据库                             整理            
   dv                                 gbk_chinese_ci    
   information_schema                 utf8_general_ci    
   mysql                              utf8_general_ci    
直接用show  databases只能显示出数据库名，不能显示出是什么类型，请问怎么才能显示出来,以及表类型，字段类型

Answer 1

用 information_schema 数据库里的 SCHEMATA 表里的数据。mysql> select schema_name,default_character_set_name from information_schema.schemata;
+--------------------+----------------------------+
| schema_name        | default_character_set_name |
+--------------------+----------------------------+
| information_schema | utf8                       |
| mysql              | latin1                     |
| test               | latin1                     |
+--------------------+----------------------------+
3 rows in set (0.00 sec)

Answer 2

sorry, should be the below column:mysql> select schema_name,default_collation_name from information_schema.schemata;
+--------------------+------------------------+
| schema_name        | default_collation_name |
+--------------------+------------------------+
| information_schema | utf8_general_ci        |
| mysql              | latin1_swedish_ci      |
| test               | latin1_swedish_ci      |
+--------------------+------------------------+
3 rows in set (0.01 sec)