Answers

Question and Answer:

  Home  MySQL Programming

⟩ How To Show Table Names with "mysqlshow"?

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 mysqlin

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

 141 views

More Questions for you: