mysqlshow

mysqlshow

---

mysqlshow [options] [database [table [column]]]

Use this to obtain a list of databases, tables, or descriptions of tables. This utility interacts with the server and uses the SHOW DATABASES, SHOW TABLES, and SHOW 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:

--character-sets-dir= path

Specifies the directory containing character sets.

--compress, -C

Instructs the utility to compress data passed between it and the server if supported.

--debug[= options], -# options

Instructs the utility to write debugging information to the log specified along with various settings (e.g., 'd:t:o,logname').

--default-character-set= set

Specifies the default character set.

--help, -?

Displays basic help information.

--host= host, -h host

Specifies the name or IP address of the server for connection.

--keys, -k

Instructs the utility to display table indexes.

--password[= password], -p[ password]

Provides the password to pass to the server. A space is not permitted after the -p option if the password is given. If the password is not given, the user will be prompted for one.

--port= port, -P port

Specifies the port number to use for connecting to the server.

--protocol= protocol

Specifies the protocol to use when connecting to the server. The choices are TCP, SOCKET, PIPE, and MEMORY.

--socket= filename, -S filename

Provides the path and name of the server's socket file.

--status, -i

Displays additional information regarding tables.

--user= user, -u user

Specifies the username for connecting to the server.

--verbose, -v

Displays more information.

--version, -V

Displays the version of the utility.