1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
4
5
>Driver options</TITLE
7
CONTENT="Modular DocBook HTML Stylesheet Version 1.76b+
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
10
TITLE="mysql driver manual"
11
11
HREF="index.html"><LINK
72
NAME="AEN93">Chapter 3. Driver options</H1
74
>Chapter 3. Driver options</H1
74
>Your application has to initialize libdbi drivers by setting some driver options with the <TT
76
>dbi_conn_set_option()</TT
79
>dbi_conn_set_option_numeric()</TT
76
>Your application has to initialize libdbi drivers by setting some driver options with the <CODE
78
>dbi_conn_set_option()</CODE
81
>dbi_conn_set_option_numeric()</CODE
80
82
> library functions. The mysql driver supports the following options:</P
135
137
>The filename of the Unix socket used to connect to a MySQL database server running on the local machine. Provide an empty string to use the default socket.</P
138
>mysql_compression (numeric)</DT
140
>mysql_client_compress (numeric)</DT
141
143
>A value larger than zero causes the client/server communication to be compressed. Set this to zero to use no data compression.</P
146
>mysql_client_found_rows (numeric)</DT
149
>A value larger than zero causes the server to return the number of matched rows, not the number of affected rows.</P
152
>mysql_client_ignore_space (numeric)</DT
155
>A value larger than zero causes the server to accept spaces after function names.</P
158
>mysql_client_interactive (numeric)</DT
161
>A value larger than zero causes the client/server communication to use interactive_timeout instead of wait_timeout before closing an inactive connection.</P
164
>mysql_client_local_files (numeric)</DT
167
>A value larger than zero enables LOAD DATA LOCAL handling.</P
170
>mysql_client_multi_statements (numeric)</DT
173
>A value larger than zero causes server to accept multiple SQL statements in a single string, separated by semicolons (requires MySQL 4.1 or later).</P
176
>mysql_client_multi_results (numeric)</DT
179
>A value larger than zero tells the server that the client can handle multiple result sets from multiple statements. This flag is automatically set if you use mysql_client_multi_statements (requires MySQL 4.1 or later).</P
182
>mysql_client_no_schema (numeric)</DT
185
>A value larger than zero tells the server not to accept the db_name.tbl_name.col_name syntax..</P
188
>mysql_client_odbc (numeric)</DT
191
>A value larger than zero causes the server to behave more ODBC-friendly.</P