MySQL Development advanced Article series 36 Tools Mysqlshow (Database object Viewing tool)

I. Overview

The Mysqlshow Client Lookup tool, which can quickly find out which databases exist, the tables in the database, the columns or indexes in the table, are similar to the MySQL client tools, but some features are not available in MySQL client tools.
Mysqlshow is used as follows:

If you do not add any options, all databases are displayed by default, and all databases in the current MySQL are displayed below.

Two. Here are some common options for mysqlshow

2.1--count display statistics for databases and tables

If you do not specify a database, displays the name of each database, the table data, and the total number of records rows for the library. The following is a view of all databases.

If you specify a database, displays each table name for the specified database, the number of table fields, and the total number of rows. Here is the view MySQL library.

If you specify a database and a table, the field information is displayed, and the following is a user table that looks at the MySQL library.

2.2-k display all indexes in the specified table
This option displays two parts, one is the table structure of the specified table, and the second is the current index information for the specified table. The following is the user table displayed under MySQL library.

-- the following SQL statement shows the same function as above, querying the user table under the MySQL library, one for the field information, and two for the index information     Full  from MySQL. 'user'    INDEXfrom   mysql. 'user'

2.3-i Display Some status information for a table

This option is also useful for displaying the user table state information under the MySQL library.

More mysqlshow Information

MySQL Development advanced Article series 36 Tools Mysqlshow (Database object Viewing tool)