MySQL 5.1 Reference Manual  /  ...  /  mysql_set_server_option() mysql_set_server_option()

int mysql_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.

MYSQL_OPTION_MULTI_STATEMENTS_ONEnable multiple-statement support
MYSQL_OPTION_MULTI_STATEMENTS_OFFDisable multiple-statement support

If you enable multiple-statement support, you should retrieve results from calls to mysql_query() or mysql_real_query() by using a loop that calls mysql_next_result() to determine whether there are more results. For an example, see Section 21.8.16, “C API Support for Multiple Statement Execution”.

Enabling multiple-statement support with MYSQL_OPTION_MULTI_STATEMENTS_ON does not have quite the same effect as enabling it by passing the CLIENT_MULTI_STATEMENTS flag to mysql_real_connect(): CLIENT_MULTI_STATEMENTS also enables CLIENT_MULTI_RESULTS. If you are using the CALL SQL statement in your programs, multiple-result support must be enabled; this means that MYSQL_OPTION_MULTI_STATEMENTS_ON by itself is insufficient to permit the use of CALL.

Return Values

Zero for success. Nonzero if an error occurred.


Download this Manual
User Comments
  Posted by Chris Slominski on July 26, 2006
This does not do the same thing as setting CLIENT_MULTI_STATEMENTS in the call to mysql_real_connect. When you pass CLIENT_MULTI_STATEMENTS at connection time it also sets the CLIENT_MULTI_RESULTS flag. You don't appear to have control over multiple result sets when using mysql_set_server_option.
Sign Up Login You must be logged in to post a comment.