mysqlshow

mysqlshow lists databases, tables within a database, or information about columns or indexes within a table. It acts as a command-line interface to the SHOW SQL statement.

Usage

mysqlshow [options] [db_name [tbl_name [col_name]]]

If no database name is specified, mysqlshow lists all databases on the server host. If a database name but no table name is specified, all tables in the database are listed. If database and table names are specified, but no column name is specified, it lists the columns in the table. If all the names are specified, mysqlshow shows information about the given column.

If the final argument contains a shell wildcard ('*' or '?'), output is limited to values that match the wildcard. '*' and '?' are treated ...

Get MySQL 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.