MySQL Programming Question:
How To Show Table Names with "mysqlshow"?
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.
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.
Previous Question | Next Question |
What Is "mysqlshow"? | What Is "mysqldump"? |