Seth Woolley's Man Viewer

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

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

mysqlshow(1)                    MySQL database                    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(3,n,1 builtins)

       -c|--character-sets-dir=...
              Directory where character sets are

       -C|--compress
              Use compression in(1,8) server/client protocol

       -h|--host=...
              connect to host(1,5)

       -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(1,n) to use for connection

       -u|--user=#
              user for login(1,3,5) if(3,n) not current user

       -V|--version
              output version(1,3,5) information and exit(3,n,1 builtins)



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(1,8)  database are shown If no column is given then all
       matching columns and columntypes in(1,8) 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,3)(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.21    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.0                      19 December 2000                   mysqlshow(1)

References for this manual (incoming links)