Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - List Table Names with "mysqlshow" Command

By: FYIcenter.com

(Continued from previous topic...)

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

(Continued on next topic...)

  1. What Tools Available for Managing MySQL Server?
  2. What Is "mysqld"?
  3. What Is "mysqladmin"?
  4. How To Check Server Status with "mysqladmin"?
  5. How To Shut Down the Server with "mysqladmin"?
  6. What Is "mysql"?
  7. How To Use "mysql" to Run SQL Statements?
  8. How To Show All Tables with "mysql"?
  9. What Is "mysqlcheck"?
  10. How To Analyze Tables with "mysqlcheck"?
  11. What Is "mysqlshow"?
  12. How To Show Table Names with "mysqlshow"?
  13. What Is "mysqldump"?
  14. How To Dump a Table to a File with "mysqldump"?
  15. What Is "mysqlimport"?
  16. How To Load Data Files into Tables with "mysqlimport"?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...