MySQL :: MySQL 8.0 C API Developer Guide :: 5.4.79 mysql_set_server_option() (original) (raw)

The world's most popular open source database

5.4.79 mysql_set_server_option()

int
mysql_set_server_option(MYSQL *mysql, enum
                        enum_mysql_set_option option)

Description

Enables or disables an option for the connection.option can have one of the following values.

If you enable multiple-statement support, you should retrieve results from calls tomysql_real_query() ormysql_query() by using a loop that calls mysql_next_result() to determine whether there are more results. For an example, see Section 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 that MYSQL_OPTION_MULTI_STATEMENTS_ON by itself is insufficient to permit the use ofCALL.

Return Values

Zero for success. Nonzero if an error occurred.

Errors

• CR_COMMANDS_OUT_OF_SYNC
  Commands were executed in an improper order.
• CR_SERVER_GONE_ERROR
  The MySQL server has gone away.
• CR_SERVER_LOST
  The connection to the server was lost during the query.
• ER_UNKNOWN_COM_ERROR
  The server did not supportmysql_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.