4. Syntaxe
4-4 mysqlshow
mysqlshow Ver 6.0 Distrib 3.21.24-gamma, for sun-solaris2.6 (sparc)
TCX Datakonsult AB, by Monty
This software comes with ABSOLUTELY NO WARRANTY
Shows the structure of a mysql database (databases,tables and fields)
Usage: mysqlshow [OPTIONS] [database [table [field]]]
-#, --debug=... output debug log. Often this is 'd:t:o,filename'
-?, --help display this help and exit
-h, --host=... connect to host
-k, --keys show keys for 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
If last argument contains a shell 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 field is given then all matching fields and fieldtypes in table
are shown