Name
mysqlshow
Synopsis
mysqlshow [options
] [database
[table
[column
]]]
Use this utility to obtain a list of databases, tables, or
descriptions of tables. It 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 workrequests work_req
The results of this command will be the same as entering the following SQL statement from the mysql client:
SHOW TABLE workrequests.work_req;
Here is an alphabetical list of options that you can give as part of the first argument of the utility, along with a brief explanation of each.
mysqlshow options
--character-sets-dir=
path
This option specifies the directory containing character sets.
--compress
,-C
This option compresses data passed between the utility and the server, if compression is supported.
--count
This option returns the number of rows for the given table.
--debug[=
,options
]-# [
options
]This option logs debugging information. The set of options used by default is
'd:t:o,logname'
. See Table 16-1 at the end of the list themysqldump
utility options earlier in this chapter for an explanation of these flags and others that may be used.--debug-check
This option writes debugging information to the log when the utility ends. ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.