Use this to obtain a list of
databases, tables, or descriptions of tables. This utility interacts
with the server and uses the
SHOW TABLES, and
TABLE statements. If no database name is given for
the second argument, all database names will be listed. If a database
name is given along with a table name, the table named will be
described. To limit information to specific columns, list the columns
desired in the fourth argument:
mysqlshow --user=russell -ppassword db1 table1
The results of this command will be the same as entering the following SQL statement from the mysql client:
SHOW TABLE db1.table1;
Here is an alphabetical list of options that you can give as part of the first argument to the utility along with a brief explanation of each:
Specifies the directory containing character sets.
Instructs the utility to compress data passed between it and the server if supported.
Instructs the utility to write debugging information to the log specified along with various settings (e.g., ‘d:t:o,logname').
Specifies the default character set.
Displays basic help information.
Specifies the name or IP address of the server for connection.
Instructs the utility to display table indexes.
Provides the password to pass to the ...