MySQL Programming Question:

How To Show Table Names with "mysqlshow"?

Tweet Share WhatsApp

Answer:

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%
<pre>+---------------------------+----------+
| Tables | Columns |
+---------------------------+----------+
| time_zone | 2 |
| time_zone_leap_second | 2 |
| time_zone_name | 2 |
| time_zone_transition | 3 |
| time_zone_transition_type | 5 |
+---------------------------+----------+</pre>
5 rows in set.

Download MySQL Programming PDF Read All 110 MySQL Programming Questions
Previous QuestionNext Question
What Is "mysqlshow"?What Is "mysqldump"?