MySQL Programming Question:

What Is "mysqlshow"?

Tweet Share WhatsApp

Answer:

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

Download MySQL Programming PDF Read All 110 MySQL Programming Questions
Previous QuestionNext Question
How To Analyze Tables with "mysqlcheck"?How To Show Table Names with "mysqlshow"?