mysqlshow is a command-line interface for end users to see information on tables and columns. The following commands are 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.
