MySQL database                                       mysqlshow(1)



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

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]

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



MySQL 4.0         Last change: 19 December 2000                 1






MySQL database                                       mysqlshow(1)



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),  mysqlad-
     min(1),    mysqld(1),    mysqldmulti(1),    mysqldsafe(1),
     mysqldump(1),  mysqlfixprivilegetables(1),  mysqlzap(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
     (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 Archi-
     tect / system developer (http:/www.mercurmedia.com)


ATRIBUTES
     See attributes(5) for descriptions of the  following  attri-
     butes:

     
       ATRIBUTE TYPE              ATRIBUTE VALUE          
    
     Availability         SUNWmysqlr, SUNWmysqlu, SUNWmysqlt
    
     Interface Stability  External                          
    

NOTES
     Source for mysql is available on http:/opensolaris.org.











MySQL 4.0         Last change: 19 December 2000                 2