MySQL Manual
4 Database Administration
- 4.8 MySQL Client-Side Scripts and Utilities
- 4.8.1 Overview of the Client-Side Scripts and Utilities
- 4.8.2
mysql, The Command-line Tool - 4.8.3
mysqladmin, Administrating a MySQL Server - 4.8.4
mysqlbinlog, Executing the queries from a binary log - 4.8.5 Using
mysqlcheckfor Table Maintenance and Crash Recovery - 4.8.6
mysqldump, Dumping Table Structure and Data - 4.8.7
mysqlhotcopy, Copying MySQL Databases and Tables - 4.8.8
mysqlimport, Importing Data from Text Files - 4.8.9
mysqlshow, Showing Databases, Tables, and Columns - 4.8.10
mysql_config, Get compile options for compiling clients - 4.8.11
perror, Explaining Error Codes - 4.8.12 How to Run SQL Commands from a Text File
4.8.9 mysqlshow, Showing Databases, Tables, and Columns
mysqlshow can be used to quickly look at which databases exist,
their tables, and the table's columns.
With the mysql program you can get the same information with the
SHOW commands. See section 4.5.7 SHOW Syntax.
mysqlshow is invoked like this:
shell> mysqlshow [OPTIONS] [database [table [column]]]
- If no database is given, all matching databases are shown.
- If no table is given, all matching tables in the database are shown.
- If no column is given, all matching columns and column types in the table are shown.
Note that in newer MySQL versions, you only see those database/tables/columns for which you have some privileges.
If the last argument contains a shell or SQL wildcard (*,
?, % or _) then only what's matched by the wildcard
is shown. If a database contains underscore(s), those should be escaped
with backslash (some Unix shells will require two), in order to get
tables / columns properly. '*' are converted into SQL '%' wildcard and
'?' into SQL '_' wildcard. This may cause some confusion when you try
to display the columns for a table with a _ as in this case
mysqlshow only shows you the table names that match the pattern.
This is easily fixed by adding an extra % last on the
command-line (as a separate argument).
