Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - What Is "mysqlshow" Command

By: FYIcenter.com

(Continued from previous topic...)

What Is "mysqlshow"?

"mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow":

  • "mysqlshow" - Shows all the databases.
  • "mysqlshow databaseName" - Shows all the tables in the specified database.
  • "mysqlshow databaseName tableName" - Shows all the columns in the specified table.
  • "mysqlshow --verbose" - Shows all the databases with extra information.
  • "mysqlshow --verbose my%" - Shows all the databases who's names match the pattern "my%" with extra information.
  • "mysqlshow --verbose mysql time%" - Shows all the tables who's names match the pattern "time%" in "mysql" database with extra information.

To know about "mysqlshow", read other parts of this FAQ collection.

(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:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: