mariadb/mysqlshow(1)

1MARIADB-SHOW(1)             MariaDB Database System            MARIADB-SHOW(1)
2
3
4

NAME

6       mariadb-show - display database, table, and column information
7       (mysqlshow is now a symlink to mariadb-show)
8

SYNOPSIS

10       mysqlshow [options] [db_name [tbl_name [col_name]]]
11

DESCRIPTION

13       The mysqlshow client can be used to quickly see which databases exist,
14       their tables, or a table´s columns or indexes.
15
16       mysqlshow provides a command-line interface to several SQL SHOW
17       statements. The same information can be obtained by using those
18       statements directly. For example, you can issue them from the mysql
19       client program.
20
21       Invoke mysqlshow like this:
22
23           shell> mysqlshow [options] [db_name [tbl_name [col_name]]]
24
25       •   If no database is given, a list of database names is shown.
26
27       •   If no table is given, all matching tables in the database are
28           shown.
29
30       •   If no column is given, all matching columns and column types in the
31           table are shown.
32
33       The output displays only the names of those databases, tables, or
34       columns for which you have some privileges.
35
36       If the last argument contains shell or SQL wildcard characters (“*”,
37       “?”, “%”, or “_”), only those names that are matched by the wildcard
38       are shown. If a database name contains any underscores, those should be
39       escaped with a backslash (some Unix shells require two) to get a list
40       of the proper tables or columns.  “*” and “?”  characters are converted
41       into SQL “%” and “_” wildcard characters. This might cause some
42       confusion when you try to display the columns for a table with a “_” in
43       the name, because in this case, mysqlshow shows you only the table
44       names that match the pattern. This is easily fixed by adding an extra
45       “%” last on the command line as a separate argument.
46
47       mysqlshow supports the following options, which can be specified on the
48       command line or in the [mysqlshow] and [client] option file groups.
49       mysqlshow also supports the options for processing option files
50       described.
51
52       •   --help, -?
53
54           Display a help message and exit.
55
56       •   --character-sets-dir=path, -c path
57
58           The directory where character sets are installed.
59
60       •   --compress, -C
61
62           Compress all information sent between the client and the server if
63           both support compression.
64
65       •   --count
66
67           Show the number of rows per table. This can be slow for non-MyISAM
68           tables.
69
70       •   --debug[=debug_options], -# [debug_options]
71
72           Write a debugging log. A typical debug_options string is
73           ´d:t:o,file_name´. The default is ´d:t:o´.
74
75       •   --debug-check
76
77           Print some debugging information when the program exits.
78
79       •   --debug-info
80
81           Print debugging information and memory and CPU usage statistics
82           when the program exits.
83
84       •   --default-auth=name
85
86           Default authentication client-side plugin to use.
87
88       •   --default-character-set=charset_name
89
90           Use charset_name as the default character set.
91
92       •   --defaults-extra-file=filename
93
94           Set filename as the file to read default options from after the
95           global defaults files has been read.  Must be given as first
96           option.
97
98       •   --defaults-file=filename
99
100           Set filename as the file to read default options from, override
101           global defaults files.  Must be given as first option.
102
103       •   --defaults-group-suffix=suffix
104
105           In addition to the groups named on the command line, read groups
106           that have the given suffix.
107
108       •   --host=host_name, -h host_name
109
110           Connect to the MariaDB server on the given host.
111
112       •   --keys, -k
113
114           Show table indexes.
115
116       •   --no-defaults
117
118           Do not read default options from any option file. This must be
119           given as the first argument.
120
121       •   --password[=password], -p[password]
122
123           The password to use when connecting to the server. If you use the
124           short option form (-p), you cannot have a space between the option
125           and the password. If you omit the password value following the
126           --password or -p option on the command line, mysqlshow prompts for
127           one.
128
129           Specifying a password on the command line should be considered
130           insecure. You can use an option file to avoid giving the password
131           on the command line.
132
133       •   --pipe, -W
134
135           On Windows, connect to the server via a named pipe. This option
136           applies only if the server supports named-pipe connections.
137
138       •   --plugin-dir=dir_name
139
140           Directory for client-side plugins.
141
142       •   --port=port_num, -P port_num
143
144           The TCP/IP port number to use for the connection.
145
146       •   --protocol={TCP|SOCKET|PIPE|MEMORY}
147
148           The connection protocol to use for connecting to the server. It is
149           useful when the other connection parameters normally would cause a
150           protocol to be used other than the one you want.
151
152       •   --print-defaults
153
154           Print the program argument list and exit.  This must be given as
155           the first argument.
156
157       •   --show-table-type, -t
158
159           Show a column indicating the table type, as in SHOW FULL TABLES.
160           The type is BASE TABLE or VIEW.
161
162       •   --socket=path, -S path
163
164           For connections to localhost, the Unix socket file to use, or, on
165           Windows, the name of the named pipe to use.
166
167       •   --ssl
168
169           Enable SSL for connection (automatically enabled with other flags).
170           Disable with --skip-ssl.
171
172       •   --ssl-ca=name
173
174           CA file in PEM format (check OpenSSL docs, implies --ssl).
175
176       •   --ssl-capath=name
177
178           CA directory (check OpenSSL docs, implies --ssl).
179
180       •   --ssl-cert=name
181
182           X509 cert in PEM format (check OpenSSL docs, implies --ssl).
183
184       •   --ssl-cipher=name
185
186           SSL cipher to use (check OpenSSL docs, implies --ssl).
187
188       •   --ssl-key=name
189
190           X509 key in PEM format (check OpenSSL docs, implies --ssl).
191
192       •   --ssl-crl=name
193
194           Certificate revocation list (check OpenSSL docs, implies --ssl).
195
196       •   --ssl-crlpath=name
197
198           Certificate revocation list path (check OpenSSL docs, implies
199           --ssl).
200
201       •   --ssl-verify-server-cert
202
203           Verify server's "Common Name" in its cert against hostname used
204           when connecting. This option is disabled by default.
205
206       •   --status, -i
207
208           Display extra information about each table.
209
210       •   --user=user_name, -u user_name
211
212           The MariaDB user name to use when connecting to the server.
213
214       •   --verbose, -v
215
216           Verbose mode. Print more information about what the program does.
217           This option can be used multiple times to increase the amount of
218           information.
219
220       •   --version, -V
221
222           Display version information and exit.
223

COPYRIGHT

225       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.,
226       2010-2019 MariaDB Foundation
227
228       This documentation is free software; you can redistribute it and/or
229       modify it only under the terms of the GNU General Public License as
230       published by the Free Software Foundation; version 2 of the License.
231
232       This documentation is distributed in the hope that it will be useful,
233       but WITHOUT ANY WARRANTY; without even the implied warranty of
234       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
235       General Public License for more details.
236
237       You should have received a copy of the GNU General Public License along
238       with the program; if not, write to the Free Software Foundation, Inc.,
239       51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see
240       http://www.gnu.org/licenses/.
241
242

AUTHOR

248       MariaDB Foundation (http://www.mariadb.org/).
249
250
251
252MariaDB 10.5                     27 June 2019                  MARIADB-SHOW(1)

NAME

SYNOPSIS

DESCRIPTION

COPYRIGHT

SEE ALSO

AUTHOR