MySQL 5.7 C API Developer Guide / C API Function Reference
The following table summarizes all functions available for the MySQL C API. For greater detail, see the individual function descriptions.
Table 4.1 C API Functions
| Name | Description | Deprecated |
|---|---|---|
my_init() | Initialize client library global variables | |
mysql_affected_rows() | Number of rows changed/deleted/inserted by lastUPDATE,DELETE, orINSERT statement | |
mysql_autocommit() | Set autocommit mode | |
mysql_change_user() | Change user and database on an open connection | |
mysql_character_set_name() | Default character set name for current connection | |
mysql_client_find_plugin() | Return pointer to a plugin | |
mysql_client_register_plugin() | Register a plugin | |
mysql_close() | Close connection to server | |
mysql_commit() | Commit transaction | |
mysql_connect() | Connect to MySQL server | Yes |
mysql_create_db() | Create database | Yes |
mysql_data_seek() | Seek to arbitrary row number in query result set | |
mysql_debug() | PerformDBUG_PUSH with given string | |
mysql_drop_db() | Drop database | Yes |
mysql_dump_debug_info() | Cause server to write debug information to error log | |
mysql_eof() | Determine whether last row of result set has been read | Yes |
mysql_errno() | Error number for most recently invoked MySQL function | |
mysql_error() | Error message for most recently invoked MySQL function | |
mysql_escape_string() | Escape special characters in string for use in SQL statement | |
mysql_fetch_field() | Type of the next table field | |
mysql_fetch_field_direct() | Table field type for given field number | |
mysql_fetch_fields() | Return array of all field structures | |
mysql_fetch_lengths() | Return lengths of all columns in current row | |
mysql_fetch_row() | Fetch next result set row | |
mysql_field_count() | Number of result columns for most recent statement | |
mysql_field_seek() | Seek to column within result set row | |
mysql_field_tell() | Field position for lastmysql_fetch_field() call | |
mysql_free_result() | Free result set memory | |
mysql_get_character_set_info() | Information about default character set | |
mysql_get_client_info() | Client version (string) | |
mysql_get_client_version() | Client version (integer) | |
mysql_get_host_info() | Information about the connection | |
mysql_get_option() | Value of amysql_options() option | |
mysql_get_proto_info() | Protocol version used by the connection | |
mysql_get_server_info() | Server version number (string) | |
mysql_get_server_version() | Server version number (integer) | |
mysql_get_ssl_cipher() | Current SSL cipher | |
mysql_hex_string() | Encode string in hexadecimal format | |
mysql_info() | Information about most recently executed statement | |
mysql_init() | Get or initialize aMYSQL structure | |
mysql_insert_id() | ID generated for anAUTO_INCREMENT column by previous statement | |
mysql_kill() | Kill a thread | Yes |
mysql_library_end() | Finalize MySQL C API library | |
mysql_library_init() | Initialize MySQL C API library | |
mysql_list_dbs() | Return database names matching regular expression | |
mysql_list_fields() | Return field names matching regular expression | 5.7.11 |
mysql_list_processes() | List of current server threads | 5.7.11 |
mysql_list_tables() | Return table names matching regular expression | |
mysql_load_plugin() | Load a plugin | |
mysql_load_plugin_v() | Load a plugin | |
mysql_more_results() | Check whether more results exist | |
mysql_next_result() | Return/initiate next result in multiple-result execution | |
mysql_num_fields() | Number of columns in result set | |
mysql_num_rows() | Number of rows in result set | |
mysql_options() | Set option prior to connecting | |
mysql_options4() | Set option prior to connecting | |
mysql_ping() | Ping server | |
mysql_plugin_options() | Set plugin option | |
mysql_query() | Execute statement | |
mysql_real_connect() | Connect to MySQL server | |
mysql_real_escape_string() | Encode special characters in statement string | |
mysql_real_escape_string_quote() | Encode special characters in statement string accounting for quoting context | |
mysql_real_query() | Execute statement | |
mysql_refresh() | Flush or reset tables and caches | 5.7.11 |
mysql_reload() | Reload grant tables | Yes |
mysql_reset_connection() | Reset the connection to clear session state | |
mysql_rollback() | Roll back transaction | |
mysql_row_seek() | Seek to row offset in result set | |
mysql_row_tell() | Current position within result set row | |
mysql_select_db() | Select database | |
mysql_server_end() | Finalize MySQL C API library | Yes |
mysql_server_init() | Initialize MySQL C API library | Yes |
mysql_session_track_get_first() | First part of session state-change information | |
mysql_session_track_get_next() | Next part of session state-change information | |
mysql_set_character_set() | Set current connection default character set | |
mysql_set_local_infile_default() | SetLOAD DATA LOCAL handler callbacks to default values | |
mysql_set_local_infile_handler() | Install application-specificLOAD DATA LOCAL handler callbacks | |
mysql_set_server_option() | Set option for current connection | |
mysql_shutdown() | Shut down MySQL server | Yes |
mysql_sqlstate() | SQLSTATE value for most recently invoked MySQL function | |
mysql_ssl_set() | Prepare to establish SSL connection to server | |
mysql_stat() | Server status | |
mysql_stmt_affected_rows() | Number of rows changed/deleted/inserted by last preparedUPDATE,DELETE, orINSERT statement | |
mysql_stmt_attr_get() | Get attribute value for prepared statement | |
mysql_stmt_attr_set() | Set attribute value for prepared statement | |
mysql_stmt_bind_param() | Associate application data buffers with parameter markers in prepared statement | |
mysql_stmt_bind_result() | Associate application data buffers with columns in result set | |
mysql_stmt_close() | Free memory used by prepared statement | |
mysql_stmt_data_seek() | Seek to arbitrary row number in prepared statement result set | |
mysql_stmt_errno() | Error number for most recently invoked MySQL prepared-statement function | |
mysql_stmt_error() | Error message for most recently invoked MySQL prepared-statement function | |
mysql_stmt_execute() | Execute prepared statement | |
mysql_stmt_fetch() | Fetch next result set row and return data for all bound columns | |
mysql_stmt_fetch_column() | Fetches data for one column of current result set row | |
mysql_stmt_field_count() | Number of result columns for most recent prepared statement | |
mysql_stmt_free_result() | Free resources allocated to statement handler | |
mysql_stmt_init() | Allocate and initialize memory forMYSQL_STMT structure | |
mysql_stmt_insert_id() | ID generated for anAUTO_INCREMENT column by previous prepared statement | |
mysql_stmt_next_result() | Return/initiate next result in multiple-result prepared statement execution | |
mysql_stmt_num_rows() | Row count from buffered statement result set | |
mysql_stmt_param_count() | Number of parameters in prepared statement | |
mysql_stmt_param_metadata() | Return parameter metadata as result set | |
mysql_stmt_prepare() | Prepare statement for execution | |
mysql_stmt_reset() | Reset statement buffers on server side | |
mysql_stmt_result_metadata() | Return prepared statement metadata as result set | |
mysql_stmt_row_seek() | Seek to row offset in prepared statement result set | |
mysql_stmt_row_tell() | Current position within prepared statement result set row | |
mysql_stmt_send_long_data() | Send long data in chunks to server | |
mysql_stmt_sqlstate() | SQLSTATE value for most recently invoked MySQL prepared-statement function | |
mysql_stmt_store_result() | Retrieve and store entire result set | |
mysql_store_result() | Retrieve and store entire result set | |
mysql_thread_end() | Finalize thread handler | |
mysql_thread_id() | Current thread ID | |
mysql_thread_init() | Initialize thread handler | |
mysql_thread_safe() | Whether client is compiled thread-safe | |
mysql_use_result() | Initiate row-by-row result set retrieval | |
mysql_warning_count() | Warning count for previous statement |