Answers

Question and Answer:

  Home  MySQL Programming

⟩ What Is "mysqlshow"?

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

 149 views

More Questions for you: