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

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

mysql
— The MySQL Command-Line Tool
269
•
--raw
[269] ,
-r
For tabular output, the “boxing” around columns enables one column value to be distinguished from
another. For nontabular output (such as is produced in batch mode or when the
--batch
[265]
or
--silent
[269] option is given), special characters are escaped in the output so they can
be identified easily. Newline, tab,
NUL
, and backslash are written as
\n
,
\t
,
\0
, and
\\
. The
--
raw
[269] option disables this character escaping.
The following example demonstrates tabular versus nontabular output and the use of raw mode to
disable escaping:
% mysql
mysql> SELECT CHAR(92);
+----------+
| CHAR(92) |
+----------+
| \ |
+----------+
% mysql -s
mysql> SELECT CHAR(92);
CHAR(92)
\\
% mysql -s -r
mysql> SELECT CHAR(92);
CHAR(92)
\
•
--reconnect
[269]
If the connection to the server is lost, automatically try to reconnect. A single reconnect attempt
is made each time the connection is lost. To suppress reconnection behavior, use
--skip-
reconnect
[269] .
•
--safe-updates
[269] ,
--i-am-a-dummy
[269] ,
-U
Permit only those
UPDATE
and
DELETE
statements that specify which rows to modify by using
key values. If you have set this option in an option file, you can override it by using
--safe-
updates
[269] on the command line. See Section 4.5.1.6, “
mysql
Tips” , for more information
about this option.
•
--secure-auth
[269]
Do not send passwords to the server in old (pre-4.1.1) format. This prevents connections except for
servers that use the newer password format.
•
--show-warnings
[269]
Cause warnings to be shown after each statement if there are any. This option applies to interactive
and batch mode. This option was added in MySQL 5.0.6.
•
--sigint-ignore
[269]
Ignore
SIGINT
signals (typically the result of typing C).
•
--silent
[269] ,
-s
Silent mode. Produce less output. This option can be given multiple times to produce less and less
output.
This option 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.
•
--skip-column-names
[269] ,
-N