What Is "mysqlshow" Command in MySQL

Q

What Is "mysqlshow" in MySQL?

✍: 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.

 

Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-16, 208👍, 0💬