What Is "mysqlshow" Command in MySQL


What Is "mysqlshow" in MySQL?

✍: FYIcenter.com


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


Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2018-02-28, 694👍, 0💬