Name
mysqlshow
Synopsis
mysqlshow [options] [database] [table] [field]
Displays the layout of the requested database, table or field. If no argument is given, a list of all of the databases is given. With one argument the layout of the given database is show. With two arguments, a table within the database is displayed. If all three arguments are present, the information about a specific field within a table is presented.
Options
- -?, --help
Display usage information.
- -# debuglevel, --debug=debuglevel
Set the debugging level. A list of all of the available options can be found at http://www.turbolift.com/mysql/appendixC.html.
- -h hostname, --host=hostname
Connect to a remote database server.
- -k, --keys
Display the keys of a table.
- -p [password], --password]=password]
Password used to connect to the database server. If no argument is given, the password is asked from the command line.
- -P port, --port=port
Port used to connect to a remote database server.
- -S file, --socket=file
The Unix socket used to connect to the local database server.
- -u username, --user=username
Username used to connect to the database server.
- -V, --version
Display version information.
Get MySQL and mSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
