How To Show Table Names with "mysqlshow"

Q

How To Show Table Names with "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server

✍: 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.

2007-05-11, 4604👍, 0💬