mysqlshow

mysqlshow 客户端对象查找工具，用来很快地查找存在哪些数据库、数据表、表中的列或索引。

语法

mysqlshow [options] [db_name [table_name [col_name]]]

参数

选项	说明
--count	显示数据库及表的统计信息（数据库、表均可不指定）
-i	显示指定数据库或者指定数据表的状态信息

示例

mysqlshow -u root -p

+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| heros              |
| mysql              |
| nba                |
| performance_schema |
| sys                |
| test               |
+--------------------+

--count

mysqlshow -u root -p --count

+--------------------+--------+--------------+
|     Databases      | Tables |  Total Rows  |
+--------------------+--------+--------------+
| information_schema |     61 |        14194 |
| heros              |      1 |           69 |
| mysql              |     31 |         3542 |
| nba                |      5 |           65 |
| performance_schema |     87 |        39053 |
| sys                |    101 |         5018 |
| test               |      6 |           27 |
+--------------------+--------+--------------+

mysqlshow -u root -p --count test

+-----------+----------+------------+
|  Tables   | Columns  | Total Rows |
+-----------+----------+------------+
| DEPT      |        3 |          4 |
| EMP       |        8 |         14 |
| SALGRADE  |        3 |          5 |
| t_class   |        2 |          2 |
| t_student |        3 |          2 |
| t_user    |        2 |          0 |
+-----------+----------+------------+

mysqlshow -u root -p --count test t_user

Database: test  Wildcard: t_user
+--------+----------+------------+
| Tables | Columns  | Total Rows |
+--------+----------+------------+
| t_user |        2 |          0 |
+--------+----------+------------+

-i

mysqlshow -u root -p -i test

Database: test
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+
| Name      | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation          | Checksum | Create_options | Comment |
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+
| DEPT      | InnoDB | 10      | Dynamic    | 4    | 4096           | 16384       | 0               | 0            | 0         |                | 2020-08-28 14:00:58 |                     |            | utf8mb4_general_ci |          |                |         |
| EMP       | InnoDB | 10      | Dynamic    | 14   | 1170           | 16384       | 0               | 0            | 0         |                | 2020-08-28 14:00:58 | 2020-08-29 16:51:03 |            | utf8mb4_general_ci |          |                |         |
| SALGRADE  | InnoDB | 10      | Dynamic    | 5    | 3276           | 16384       | 0               | 0            | 0         |                | 2020-08-28 14:00:58 |                     |            | utf8mb4_general_ci |          |                |         |
| t_class   | InnoDB | 10      | Dynamic    | 2    | 8192           | 16384       | 0               | 0            | 0         |                | 2020-08-28 14:00:58 |                     |            | utf8mb4_general_ci |          |                |         |
| t_student | InnoDB | 10      | Dynamic    | 2    | 8192           | 16384       | 0               | 16384        | 0         |                | 2020-08-28 14:00:58 |                     |            | utf8mb4_general_ci |          |                |         |
| t_user    | InnoDB | 10      | Dynamic    | 0    | 0              | 16384       | 0               | 0            | 0         | 1              | 2020-08-28 14:00:58 |                     |            | utf8mb4_general_ci |          |                |         |
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+

mysqlshow -u root -p -i test t_user

Database: test  Wildcard: t_user
+--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| Name   | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation          | Checksum | Create_options | Comment |
+--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| t_user | InnoDB | 10      | Dynamic    | 0    | 0              | 16384       | 0               | 0            | 0         | 1              | 2020-08-28 14:00:58 |             |            | utf8mb4_general_ci |          |                |         |
+--------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+