SBDavid
Mar 3rd, 2013
Mar 3rd, 2013
mysqlshow - display database, table, and column information
mysqlshow - display database, table, and column information
SYNOPSIS
mysqlshow [options] [db_name [tbl_name [col_name]]]
DESCRIPTION
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table´s columns or indexes.
mysqlshow provides a command-line interface to several SQL SHOW statements.
The same information can be obtained by using those statements directly.
For example, you can issue them from the mysql client program.
Invoke mysqlshow like this:
shell> mysqlshow [options] [db_name [tbl_name [col_name]]]
If no database is given, a list of database names is shown.
If no table is given, all matching tables in the database are shown.
