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)