![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196287.webp)
mysql
— The MySQL Command-Line Tool
267
Connect to the MySQL server on the given host.
•
--html
[267]
,
-H
Produce HTML output.
•
--ignore-spaces
[267]
,
-i
Ignore spaces after function names. The effect of this is described in the discussion for the
IGNORE_SPACE
[536]
SQL mode (see
Section 5.1.7, “Server SQL Modes”
).
•
--line-numbers
[267]
Write line numbers for errors. Disable this with
--skip-line-numbers
[270]
.
•
--local-infile[={0|1}]
[267]
Enable or disable
LOCAL
capability for
LOAD DATA INFILE
. With no value, the option enables
LOCAL
. The option may be given as
--local-infile=0
[267]
or
--local-infile=1
[267]
to
explicitly disable or enable
LOCAL
. Enabling
LOCAL
has no effect if the server does not also support
it.
•
--named-commands
[267]
,
-G
Enable named
mysql
commands. Long-format commands are permitted, not just short-
format commands. For example,
quit
and
\q
both are recognized. Use
--skip-named-
commands
[267]
to disable named commands. See
Section 4.5.1.2, “
mysql
Commands”
.
•
--no-auto-rehash
[265]
,
-A
This has the same effect as
-skip-auto-rehash
. See the description for
--auto-
rehash
[265]
.
•
--no-beep
[267]
,
-b
Do not beep when errors occur.
•
--no-named-commands
[267]
,
-g
Deprecated, use
--disable-named-commands
[266]
instead.
--no-named-commands
[267]
is removed in MySQL 5.5.
•
--no-pager
[267]
Deprecated form of
--skip-pager
[268]
. See the
--pager
[268]
option.
--no-pager
[267]
is removed in MySQL 5.5.
•
--no-tee
[267]
Deprecated form of
--skip-tee
[270]
. See the
--tee
[270]
option.
--no-tee
[267]
is
removed in MySQL 5.5.
•
--one-database
[267]
,
-o
Ignore statements except those that occur while the default database is the one named on the
command line. This option is rudimentary and should be used with care. Statement filtering is based
only on
USE
statements.
Initially,
mysql
executes statements in the input because specifying a database
db_name
on the
command line is equivalent to inserting
USE db_name
at the beginning of the input. Then, for each
USE
statement encountered,
mysql
accepts or rejects following statements depending on whether
the database named is the one on the command line. The content of the statements is immaterial.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...