mysqlshow

Display database related information in MySQL

Supplementary instructions

mysqlshow command is used to display database, table and list information in the mysql server.

grammar

mysqlshow(options)(parameters)

Options

-h: The IP address or host name of the MySQL server;
-u: Username to connect to the MySQL server;
-p: Password to connect to the MySQL server;
--count: Display the number of rows of data in each data table;
-k: Display the index of the data table;
-t: Display the type of data table;
-i: Display additional information of the data table.

Parameters

Database information: Specify the database information to be displayed, which can be a database name, database name and table name, or database name, table name and column name.