How To Show Table Names With "mysqlshow"

How To Show Table Names With "mysqlshow"


  • 23 Dec, 2011

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

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.