MySQL :: MySQL 9.4 C API Developer Guide :: 5.3 C API Basic Function Reference

MySQL 9.4 C API Developer Guide / C API Basic Interface / C API Basic Function Reference

5.3 C API Basic Function Reference

The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.

Table 5.1 C API Basic Interface Functions

Name	Description	Deprecated
`mysql_affected_rows()`	Number of rows changed/deleted/inserted by last `UPDATE`, `DELETE`, or `INSERT` statement
`mysql_autocommit()`	Set autocommit mode
`mysql_bind_param()`	Define query attributes for next statement executed
`mysql_change_user()`	Change user and database on an open connection
`mysql_character_set_name()`	Default character set name for current connection
`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()`	Perform `DBUG_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 last `mysql_fetch_field()` call
`mysql_free_result()`	Free result set memory
`mysql_free_ssl_session_data()`	Dispose of session data handle from last `mysql_get_ssl_session_data()` call
`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 a `mysql_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_get_ssl_session_data()`	Return session data for SSL-enabled connection
`mysql_get_ssl_session_reused()`	Whether a session is reused
`mysql_hex_string()`	Encode string in hexadecimal format
`mysql_info()`	Information about most recently executed statement
`mysql_init()`	Get or initialize a `MYSQL` structure
`mysql_insert_id()`	ID generated for an `AUTO_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	Yes
`mysql_list_processes()`	List of current server threads	Yes
`mysql_list_tables()`	Return table names matching regular expression
`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_query()`	Execute statement
`mysql_real_connect()`	Connect to MySQL server
`mysql_real_connect_dns_srv()`	Connect to MySQL server using DNS SRV record
`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	Yes
`mysql_reload()`	Reload grant tables	Yes
`mysql_reset_connection()`	Reset the connection to clear session state
`mysql_reset_server_public_key()`	Clear cached RSA public key from client library
`mysql_result_metadata()`	Whether a result set has metadata
`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()`	Set `LOAD DATA LOCAL` handler callbacks to default values
`mysql_set_local_infile_handler()`	Install application-specific `LOAD 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	Yes
`mysql_stat()`	Server status
`mysql_store_result()`	Retrieve and store entire result set
`mysql_thread_id()`	Current thread ID
`mysql_use_result()`	Initiate row-by-row result set retrieval
`mysql_warning_count()`	Warning count for previous statement

PREV HOME UP NEXT