MAN Solaris - mysqlshow (1)

advertisement


NAME

mysqlshow
- Shows the structure of a mysql database (databases,tables and columns)

CONTENTS

Usage
Synopsis
Description
Note
Bugs
Author
Attributes
Notes

USAGE

shell> mysqlshow [OPTIONS] [database [table [column]]]

SYNOPSIS

mysqlshow [-#|--debug=...] [-?|--help] [-c|--character-sets-dir=...] [-C|--compress] [-h|--host=...] [-i|--status] [-k|--keys] [-p|--password[=...]] [-P|--port=...] [-S|--socket=...] [-u|--user=#] [-V|--version]

advertisements

advertisements


DESCRIPTION

-#|--debug=...
  output debug log. Often this is ’d:t:o,filename‘
-?|--help
  display help and exit
-c|--character-sets-dir=...
  Directory where character sets are
-C|--compress
  Use compression in server/client protocol
-h|--host=...
  connect to host
-i|--status
  Shows a lot of extra information about each table
-k|--keys
  show keys for table
-p|--password[=...]
  password to use when connecting to server If password is not given it’s asked from the tty.
-P|--port=...
  Port number to use for connection
-S|--socket=...
  Socket file to use for connection
-u|--user=#
  user for login if not current user
-V|--version
  output version information and exit

NOTE

If last argument contains a shell or SQL wildcard (*,?,% or _) then only what’s matched by the wildcard is shown. If no database is given then all matching databases are shown. If no table is given then all matching tables in database are shown If no column is given then all matching columns and columntypes in table are shown

SEE ALSO

isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1), mysql_zap(1), perror(1), replace(1)

For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/

BUGS

Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius ([email protected]), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen ([email protected]), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com)

ATTRIBUTES

See attributes(5) for descriptions of the following attributes:

ATTRIBUTE TYPEATTRIBUTE VALUE
AvailabilitySUNWmysqlr, SUNWmysqlu, SUNWmysqlt
Interface StabilityExternal

NOTES

Source for mysql is available on http://opensolaris.org.
Jump to page    or go to Top of page |  Section 1 |  Main Solaris Index.


MySQL 4.0 mysqlshow (1) 19 December 2000
Generated by Open Solaris Forum from /usr/share/man/man1/mysqlshow.1 using man macros with tbl support.