List Table Names with "mysqlshow" Command in MySQL

Q

How To Show Table Names with "mysqlshow" in MySQL?

✍: FYIcenter.com

A

If you want to show table names with "mysqlshow", you need to specify a database name. The followings tutorial exercise shows you how to get all table names that match a pattern:

If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database:

>cd \mysql\bin
>mysqlshow --verbose mysql time%
Database: mysql  Wildcard: time%
+---------------------------+----------+
|          Tables           | Columns  |
+---------------------------+----------+
| time_zone                 |        2 |
| time_zone_leap_second     |        2 |
| time_zone_name            |        2 |
| time_zone_transition      |        3 |
| time_zone_transition_type |        5 |
+---------------------------+----------+
5 rows in set.

 

Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-16, 200👍, 0💬