Oracle 5.0, Справочное руководство

Страница: 285 / 3232

mysql
— The MySQL Command-Line Tool
265
Format Option File Description Introduced
--
socket=path [270] socket [270] For connections to localhost
--ssl-
ca=file_name [270] ssl-ca [270] The path to a file that contains a list of trusted SSL
CAs
--ssl-
capath=dir_name [270] ssl-capath [270] The path to a directory that contains trusted SSL
CA certificates in PEM format
--ssl-
cert=file_name [270] ssl-cert [270] The name of the SSL certificate file to use for
establishing a secure connection
--ssl-
cipher=cipher_list [270] ssl-cipher [270] A list of allowable ciphers to use for SSL
encryption
--ssl-
key=file_name [270] ssl-key [270] The name of the SSL key file to use for
establishing a secure connection
--ssl-verify-server-
cert [270] ssl-verify-server-
cert [270] The server's Common Name value in its certificate
is verified against the host name used when
connecting to the server
--table [270] table [270] Display output in tabular format
--
tee=file_name [270] tee [270] Append a copy of output to the given file
--
unbuffered [270] unbuffered [270] Flush the buffer after each query
--
user=user_name [270] user [270] MySQL user name to use when connecting to
server
--verbose [270] Verbose mode
--version [270] Display version information and exit
--vertical [270] vertical [270] Print query output rows vertically (one line per
column value)
--wait [270] wait [270] If the connection cannot be established, wait and
retry instead of aborting
--xml [270] xml [270] Produce XML output
•
--help
[265] ,
-?
Display a help message and exit.
•
--auto-rehash
[265]
Enable automatic rehashing. This option is on by default, which enables database, table, and column
name completion. Use
--disable-auto-rehash
[265] to disable rehashing. That causes
mysql
to start faster, but you must issue the
rehash
command if you want to use name completion.
To complete a name, enter the first part and press Tab. If the name is unambiguous,
mysql
completes it. Otherwise, you can press Tab again to see the possible names that begin with what
you have typed so far. Completion does not occur if there is no default database.
•
--batch
[265] ,
-B
Print results using tab as the column separator, with each row on a new line. With this option,
mysql
does not use the history file.
Batch mode results in nontabular output format and escaping of special characters. Escaping may be
disabled by using raw mode; see the description for the
--raw
[269] option.