mysqlshow - Manpage - Tux24 Net - Linux Unix Network
A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z




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|--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), mysqlaccess (1), mysqladmin (1), mysqlbug
    (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
    (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR
    Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se),
    TCX Datakonsult  AB (http://www.tcx.se). This software comes with no
    warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mer-
    curmedia  Data Model Architect / system developer (http://www.mercurme-
    dia.com)