Server System Variables
456
Version Introduced
5.0.38
Variable Name
hostname
Variable Scope
Global
Dynamic Variable
No
Permitted Values
Type
string
The server sets this variable to the server host name at startup. This variable was added in MySQL
5.0.38.
•
identity
[456]
This variable is a synonym for the
last_insert_id
[462]
variable. It exists for compatibility with
other database systems. You can read its value with
SELECT @@identity
, and set it using
SET
identity
.
•
init_connect
[456]
Command-Line Format
--init-connect=name
Option-File Format
init_connect
Option Sets Variable
Yes,
init_connect
[456]
Variable Name
init_connect
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
string
A string to be executed by the server for each client that connects. The string consists of one or more
SQL statements, separated by semicolon characters. For example, each client session begins by
default with autocommit mode enabled. There is no global
autocommit
[436]
system variable to
specify that autocommit should be disabled by default, but
init_connect
[456]
can be used to
achieve the same effect:
SET GLOBAL init_connect='SET autocommit=0';
The
init_connect
[456]
variable can also be set on the command line or in an option file. To set
the variable as just shown using an option file, include these lines:
[mysqld]
init_connect='SET autocommit=0'
The content of
init_connect
[456]
is not executed for users that have the
SUPER
[578]
privilege. This is done so that an erroneous value for
init_connect
[456]
does not prevent all
clients from connecting. For example, the value might contain a statement that has a syntax error,
thus causing client connections to fail. Not executing
init_connect
[456]
for users that have
the
SUPER
[578]
privilege enables them to open a connection and fix the
init_connect
[456]
value.
•
init_file
[456]
Command-Line Format
--init-file=file_name
Option-File Format
init-file=file_name
Option Sets Variable
Yes,
init_file
[456]
Содержание 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 ...