👤
Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:
Select Section of Man Page:
Select Man Page Repository:

OpenSolaris 2009.06 - man page for mysqlshow (opensolaris section 1)

mysqlshow(1)				  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

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),    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 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 Architect / system	developer
       (http://www.mercurmedia.com)

ATTRIBUTES
       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES
       Source for mysql is available on http://opensolaris.org.

MySQL 4.0				 19 December 2000			     mysqlshow(1)


All times are GMT -4. The time now is 06:53 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password





Not a Forum Member?
Forgot Password?