GNU Info

(mysql.info)mysqlshow

---

Next: perror Prev: mysqlimport Up: Client-Side Scripts

---

Enter node , (file) or (file)node

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.  Note: SHOW.

`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 wild-card (`*', `?', `%'
or `_') then only what's matched by the wild card is shown.  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).