- 22.8.7 C API Function Descriptions
- 22.8.7.1 mysql_affected_rows()
- 22.8.7.2 mysql_autocommit()
- 22.8.7.3 mysql_change_user()
- 22.8.7.4 mysql_character_set_name()
- 22.8.7.5 mysql_close()
- 22.8.7.6 mysql_commit()
- 22.8.7.7 mysql_connect()
- 22.8.7.8 mysql_create_db()
- 22.8.7.9 mysql_data_seek()
- 22.8.7.10 mysql_debug()
- 22.8.7.11 mysql_drop_db()
- 22.8.7.12 mysql_dump_debug_info()
- 22.8.7.13 mysql_eof()
- 22.8.7.14 mysql_errno()
- 22.8.7.15 mysql_error()
- 22.8.7.16 mysql_escape_string()
- 22.8.7.17 mysql_fetch_field()
- 22.8.7.18 mysql_fetch_field_direct()
- 22.8.7.19 mysql_fetch_fields()
- 22.8.7.20 mysql_fetch_lengths()
- 22.8.7.21 mysql_fetch_row()
- 22.8.7.22 mysql_field_count()
- 22.8.7.23 mysql_field_seek()
- 22.8.7.24 mysql_field_tell()
- 22.8.7.25 mysql_free_result()
- 22.8.7.26 mysql_get_character_set_info()
- 22.8.7.27 mysql_get_client_info()
- 22.8.7.28 mysql_get_client_version()
- 22.8.7.29 mysql_get_host_info()
- 22.8.7.30 mysql_get_proto_info()
- 22.8.7.31 mysql_get_server_info()
- 22.8.7.32 mysql_get_server_version()
- 22.8.7.33 mysql_get_ssl_cipher()
- 22.8.7.34 mysql_hex_string()
- 22.8.7.35 mysql_info()
- 22.8.7.36 mysql_init()
- 22.8.7.37 mysql_insert_id()
- 22.8.7.38 mysql_kill()
- 22.8.7.39 mysql_library_end()
- 22.8.7.40 mysql_library_init()
- 22.8.7.41 mysql_list_dbs()
- 22.8.7.42 mysql_list_fields()
- 22.8.7.43 mysql_list_processes()
- 22.8.7.44 mysql_list_tables()
- 22.8.7.45 mysql_more_results()
- 22.8.7.46 mysql_next_result()
- 22.8.7.47 mysql_num_fields()
- 22.8.7.48 mysql_num_rows()
- 22.8.7.49 mysql_options()
- 22.8.7.50 mysql_options4()
- 22.8.7.51 mysql_ping()
- 22.8.7.52 mysql_query()
- 22.8.7.53 mysql_real_connect()
- 22.8.7.54 mysql_real_escape_string()
- 22.8.7.55 mysql_real_query()
- 22.8.7.56 mysql_refresh()
- 22.8.7.57 mysql_reload()
- 22.8.7.58 mysql_rollback()
- 22.8.7.59 mysql_row_seek()
- 22.8.7.60 mysql_row_tell()
- 22.8.7.61 mysql_select_db()
- 22.8.7.62 mysql_set_character_set()
- 22.8.7.63 mysql_set_local_infile_default()
- 22.8.7.64 mysql_set_local_infile_handler()
- 22.8.7.65 mysql_set_server_option()
- 22.8.7.66 mysql_shutdown()
- 22.8.7.67 mysql_sqlstate()
- 22.8.7.68 mysql_ssl_set()
- 22.8.7.69 mysql_stat()
- 22.8.7.70 mysql_store_result()
- 22.8.7.71 mysql_thread_id()
- 22.8.7.72 mysql_use_result()
- 22.8.7.73 mysql_warning_count()
int mysql_options4(MYSQL *mysql, enum mysql_option
option, const void *arg1, const void *arg2)
Description
mysql_options4() is similar to
mysql_options() but has an extra
fourth argument so that two values can be passed for the option
specified in the second argument. This function was added in
MySQL 5.6.6.
The following list describes the permitted options, their
effect, and how arg1 and
arg2 are used.
MYSQL_OPT_CONNECT_ATTR_ADD(argument types:char *, char *)This option adds a key/value pair to the current set of connection attributes to be passed to the server at connect time. Both arguments are pointers to null-terminated strings. The first and second strings indicate the key and value, respectively. If the key already exists in the current set of connection attributes, the new value replaces the existing one. Comparison of the key name with existing keys is case sensitive.
Key names that begin with an underscore (
_) are reserved for internal use and should not be used by application programs.See also the descriptions for the
MYSQL_OPT_CONNECT_ATTR_RESETMYSQL_OPT_CONNECT_ATTR_DELETEoptions in the description of themysql_options()function.Connection attributes are exposed through the
session_connect_attrsandsession_account_connect_attrsPerformance Schema tables. See Section 21.9.7, “Performance Schema Connection Attribute Tables”.
Return Values
Zero for success. Nonzero if you specify an unknown option.
Example
This example demonstrates the calls that specify connection attributes:
MYSQL mysql;
mysql_init(&mysql);
mysql_options4(&mysql,MYSQL_OPT_CONNECT_ATTR_RESET, 0);
mysql_options4(&mysql,MYSQL_OPT_CONNECT_ATTR_ADD, "key1", "value1");
mysql_options4(&mysql,MYSQL_OPT_CONNECT_ATTR_ADD, "key2", "value2");
mysql_options4(&mysql,MYSQL_OPT_CONNECT_ATTR_ADD, "key3", "value3");
mysql_options4(&mysql,MYSQL_OPT_CONNECT_ATTR_DELETE, "key1");
if (!mysql_real_connect(&mysql,"host","user","passwd","database",0,NULL,0))
{
fprintf(stderr, "Failed to connect to database: Error: %s\n",
mysql_error(&mysql));
}
mysql_options(&mysql,MYSQL_OPT_CONNECT_ATTR_RESET, 0);
User Comments
Add your own comment.