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
3.149.243.130