intmysql_set_server_option(MYSQL *mysql, enum enum_mysql_set_option option) Enables or disables an option for the connection.option can have one of the following values.
| Option | Description |
|---|---|
MYSQL_OPTION_MULTI_STATEMENTS_ON | Enable multiple-statement support |
MYSQL_OPTION_MULTI_STATEMENTS_OFF | Disable multiple-statement support |
If you enable multiple-statement support, you should retrieve results from calls tomysql_real_query() ormysql_query() by using a loop that callsmysql_next_result() to determine whether there are more results. For an example, seeSection 3.6.3, “Multiple Statement Execution Support”.
Enabling multiple-statement support withMYSQL_OPTION_MULTI_STATEMENTS_ON does not have quite the same effect as enabling it by passing theCLIENT_MULTI_STATEMENTS flag tomysql_real_connect():CLIENT_MULTI_STATEMENTS also enablesCLIENT_MULTI_RESULTS. If you are using theCALL SQL statement in your programs, multiple-result support must be enabled; this means thatMYSQL_OPTION_MULTI_STATEMENTS_ON by itself is insufficient to permit the use ofCALL.
Commands were executed in an improper order.
The MySQL server has gone away.
The connection to the server was lost during the query.
The server did not support
mysql_set_server_option()(which is the case that the server is older than 4.1.1) or the server did not support the option one tried to set.