37.笔记 MySQL学习——命令行获取元数据

37.笔记 MySQL学习——命令行获取元数据

直接用命令行提示符号获取数据库和表的信息

如下：

[root@OEL ~]# mysqlshow  -u root -p

Enter password:

+--------------------+

|    Databases      |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sampdb             |

| sys                |

+--------------------+

查看某个数据库的表

[root@OEL ~]# mysqlshow  -u root -p sampdb

Enter password:

Database: sampdb

+---------------+

|   Tables     |

+---------------+

| absence       |

| grade_event   |

| log_partition |

| member        |

| mytbl         |

| namelist      |

| president     |

| score         |

| student       |

| t             |

查看表里的索引信息

[root@OEL ~]# mysqlshow  -u root -p --keys sampdb president

Enter password:

Database: sampdb  Table: president

+------------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+

| Field     | Type        | Collation         | Null | Key | Default | Extra |Privileges                      | Comment|

+------------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+

| last_name | varchar(15) | latin1_swedish_ci | NO  |     |         |      | select,insert,update,references |         |

| first_name | varchar(15) |latin1_swedish_ci | NO   |     |        |       |select,insert,update,references |        |

| suffix    | varchar(5)  | latin1_swedish_ci| YES  |     |        |       |select,insert,update,references |        |

| city      | varchar(20) | latin1_swedish_ci | NO  |     |         |      | select,insert,update,references |         |

| state     | varchar(2)  | latin1_swedish_ci| NO   |     |        |       |select,insert,update,references |        |

| birth     | date        |                   | NO   |    |         |       | select,insert,update,references |         |

| death     | date        |                   | YES  |     |         |      | select,insert,update,references |         |

+------------+-------------+-------------------+------+-----+---------+-------+---------------------------------+---------+

Table has no keys