![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461962196.webp)
C API Function Descriptions
2176
Note
Do not attempt to encrypt the password before calling
mysql_real_connect()
; password encryption is handled automatically by
the client API.
• The
user
and
passwd
parameters use whatever character set has been configured for the
MYSQL
object. By default, this is
latin1
, but can be changed by calling
mysql_options(mysql,
MYSQL_SET_CHARSET_NAME, "charset_name")
prior to connecting.
•
db
is the database name. If
db
is not
NULL
, the connection sets the default database to this value.
• If
port
is not 0, the value is used as the port number for the TCP/IP connection. Note that the
host
parameter determines the type of the connection.
• If
unix_socket
is not
NULL
, the string specifies the socket or named pipe to use. Note that the
host
parameter determines the type of the connection.
• The value of
client_flag
is usually 0, but can be set to a combination of the following flags to
enable certain features.
Flag Name
Flag Description
CLIENT_COMPRESS
Use compression protocol.
CLIENT_FOUND_ROWS
Return the number of found (matched) rows, not the number of
changed rows.
CLIENT_IGNORE_SIGPIPE
Prevents the client library from installing a
SIGPIPE
signal
handler. This can be used to avoid conflicts with a handler that
the application has already installed.
CLIENT_IGNORE_SPACE
Permit spaces after function names. Makes all functions names
reserved words.
CLIENT_INTERACTIVE
Permit
interactive_timeout
[457]
seconds (instead of
wait_timeout
[506]
seconds) of inactivity before closing the
connection. The client's session
wait_timeout
[506]
variable
is set to the value of the session
interactive_timeout
[457]
variable.
CLIENT_LOCAL_FILES
Enable
LOAD DATA LOCAL
handling.
CLIENT_MULTI_RESULTS
Tell the server that the client can handle multiple result sets from
multiple-statement executions or stored procedures. This flag
is automatically enabled if
CLIENT_MULTI_STATEMENTS
is
enabled. See the note following this table for more information
about this flag.
CLIENT_MULTI_STATEMENTS
Tell the server that the client may send multiple statements in
a single string (separated by “
;
”). If this flag is not set, multiple-
statement execution is disabled. See the note following this
table for more information about this flag.
CLIENT_NO_SCHEMA
Do not permit the
db_name.tbl_name.col_name
syntax. This
is for ODBC. It causes the parser to generate an error if you use
that syntax, which is useful for trapping bugs in some ODBC
programs.
CLIENT_ODBC
Unused.
CLIENT_SSL
Use SSL (encrypted protocol). Do not set this option within
an application program; it is set internally in the client
library. Instead, use
mysql_ssl_set()
before calling
mysql_real_connect()
.
Содержание 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 ...