PDF (US Ltr)
- 1.1Mb
PDF (A4)
- 1.1Mb
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 last
UPDATE,
DELETE, or
INSERT 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() |
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_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_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 | |
mysql_list_processes() |
List of current server threads | |
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 | |
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 | |
mysql_server_init() |
Initialize MySQL C API library | |
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 | |
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 prepared
UPDATE,
DELETE, or
INSERT 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 for MYSQL_STMT
structure
|
|
mysql_stmt_insert_id() |
ID generated for an AUTO_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 |