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


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


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


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


output debug log. Often this is 'd:t:o,filename`
display help and exit
Directory where character sets are
Use compression in server/client protocol
connect to host
Shows a lot of extra information about each table
show keys for table
-p|--password[=...] password to use when connecting to server If password is not given it's asked from the tty. WARNING: Providing a password on command line is insecure as it is visible through /proc to anyone for a short time.
Port number to use for connection
Socket file to use for connection
user for login if not current user
output version information and exit


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


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


Please refer to to report bugs.


Ver 1.0, distribution 4.1.15 Michael (Monty) Widenius (, MySQL AB ( This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (, Mercurmedia Data Model Architect / system developer (