MySQL - What Is "mysqlshow" Command in MySQL

"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, 386👍, 0💬