What Is "mysqlshow"

Q

What Is "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server

✍: FYIcenter.com

A

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

2007-05-11, 4669👍, 0💬