mysqlshow(1)

NAME

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

USAGE

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

SYNOPSIS

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

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.1.10a    Michael    (Monty)    Widenius
       (monty@mysql.com),  MySQL  AB  (http://www.mysql.com/).   This software
       comes  with  no  warranty.   Manual  page  by  L.   (Kill-9)   Pedersen
       (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer
       (http://www.mercurmedia.com)

MySQL 4.1                      19 December 2000                   mysqlshow(1)