C API

Di seguito un elenco di C API funzioni. Fare clic su una funzione in elenco per visualizzare ulteriori informazioni su di esso, inclusa la sua sintassi, una spiegazione del suo utilizzo, ed esempi di come può essere utilizzato per interfacciarsi con MySQL.

Use this C API function to turn on or off auto-commit mode for the MySQL connection.

mysql_change_user( )

Use this C API function to change the current user for the MySQL session to the one given as the second argument.

mysql_change_user( )

Use this C API function to change the current user for the MySQL session to the one given as the second argument.

mysql_character_set_name( )

This C API function returns the name of the default character set in use by the MySQL server.

mysql_close( )

Use this C API function to close the connection to the MySQL server.

mysql_close( )

Use this C API function to close the connection to the MySQL server.

Use this C API function to commit the current transaction of MySQL.

mysql_connect( )

This C API function is deprecated in favor of mysql_real_connect( ) for connecting to MySQL.

mysql_connect( )

This C API function is deprecated in favor of mysql_real_connect( ) for connecting to MySQL.

mysql_create_db( )

This C API function can be used to create a new database on the MySQL server, with the new database name is given as the second argument.

mysql_create_db( )

This C API function can be used to create a new database on the MySQL server, with the new database name is given as the second argument.

mysql_data_seek( )

Use this C API function in conjunction with mysql_store_result( ) and a fetch function to change the current row being fetched from MySQL.

mysql_data_seek( )

Use this C API function in conjunction with mysql_store_result( ) and a fetch function to change the current row being fetched from MySQL.

mysql_debug( )

Use this C API function to set debugging if the client for MySQL was compiled with debugging.

mysql_drop_db( )

This C API function may be used to delete the database named in the second argument of the function from the MySQL server.

mysql_drop_db( )

This C API function may be used to delete the database named in the second argument of the function from the MySQL server.

mysql_dump_debug_info( )

Use this C API function to write debugging information about the current connection to the MySQL server's logfile.

mysql_eof( )

Use this C API function to determine whether the last row of the results set has been fetched from MySQL.

mysql_errno( )

This C API function returns the MySQL error number for the last function which was run if it failed to execute.

mysql_errno( )

This C API function returns the MySQL error number for the last function which was run if it failed to execute.

mysql_error( )

This C API function returns the MySQL error message for the last function which was run if it failed to execute.

mysql_error( )

This C API function returns the MySQL error message for the last function which was run if it failed to execute.

mysql_escape_string( )

This C API function will return a string or MySQL column given with special characters escaped by adding backslashes in front of them.

mysql_escape_string( )

This C API function will return a string or MySQL column given with special characters escaped by adding backslashes in front of them.

mysql_fetch_field( )

This C API function returns a MYSQL_FIELD structure that provides information on a given field of a results set.

mysql_fetch_field( )

This C API function returns a MYSQL_FIELD structure that provides information on a given field of a results set.

This C API function returns an array of information about the fields in a MySQL results set.

mysql_fetch_field_direct( )

This C API function returns a MYSQL_FIELD structure that provides information on a given field of a results set referred to in the first argument of the function.

mysql_fetch_lengths( )

This C API function returns the length of each column within a particular row of a results set from MySQL.

mysql_fetch_lengths( )

This C API function returns the length of each column within a particular row of a results set from MySQL.

mysql_fetch_row( )

Use this C API function to retrieve the next row of a results set from MySQL.

mysql_fetch_row( )

Use this C API function to retrieve the next row of a results set from MySQL.

mysql_field_count( )

This C API function returns the number of columns in a results set from MySQL.

mysql_field_seek( )

Use this C API function in conjunction with mysql_fetch_field( ) to change the current field being fetched to the one specified in the second argument of this function.

mysql_field_seek( )

Use this C API function in conjunction with mysql_fetch_field( ) to change the current field being fetched to the one specified in the second argument of this function.

mysql_field_tell( )

This C API function returns the value of the field pointer for the current row in use by a fetch function such as mysql_fetch_field( ).

mysql_free_result( )

Use this C API function to free memory allocated under particular conditions related to MySQL.

mysql_free_result( )

Use this C API function to free memory allocated under particular conditions related to MySQL.

mysql_get_character_set_info( )

This C API function returns the default character set information for the MySQL database given.

mysql_get_client_info( )

This C API function returns the MySQL client library version.

mysql_get_client_info( )

This C API function returns the MySQL client library version.

mysql_get_client_version( )

This C API function returns the MySQL client library version in a numeric format.

mysql_get_host_info( )

This C API function returns the hostname and the connection type for the current connection to MySQL.

mysql_get_host_info( )

This C API function returns the hostname and the connection type for the current connection to MySQL.

mysql_get_proto_info( )

This C API function returns the protocol version for the current connection to MySQL.

mysql_get_proto_info( )

This C API function returns the protocol version for the current connection to MySQL.

mysql_get_server_info( )

This C API function returns a string containing the version of MySQL running on the server for the current connection.

mysql_get_server_info( )

This C API function returns a string containing the version of MySQL running on the server for the current connection.

mysql_get_server_version( )

This C API function returns the version of the MySQL server for the current connection in a numeric format.

mysql_get_ssl_cipher( )

This C API function returns a string with the name of the SSL cipher which was used for the MySQL connection given.

mysql_hex_string( )

This C API function can be used to translate a hexadecimal string to a format that can be used in a MySQL statement.

mysql_info( )

This C API function returns a string containing information provided by MySQL when certain SQL statements are executed.

mysql_info( )

This C API function returns a string containing information provided by MySQL when certain SQL statements are executed.

mysql_init( )

This C API function optionally allocates, and then initializes, a MYSQL object suitable for connecting to a MySQL server and subsequently performing many of the other operations.

mysql_insert_id( )

This C API function returns the identification number issued to the primary key of the last record inserted using INSERT in MySQL for the current connection.

mysql_insert_id( )

This C API function returns the identification number issued to the primary key of the last record inserted using INSERT in MySQL for the current connection.

mysql_kill( )

Use this C API function to terminate a thread on the MySQL server.

mysql_library_end( )

Use this C API function to close the MySQL library after disconnecting from the server.

Use this C API function to initialize the MySQL library and any related libraries and systems before making any other MySQL function calls.

mysql_list_dbs( )

This C API function returns a results set containing a list of databases found for the current connection to MySQL.

mysql_list_dbs( )

This C API function returns a results set containing a list of databases found for the current connection to MySQL.

mysql_list_fields( )

This C API function returns a results set containing a list of fields found for the MySQL table given.

mysql_list_fields( )

This C API function returns a results set containing a list of fields found for the MySQL table given.

mysql_list_processes( )

This C API function returns a results set containing a list of MySQL server processes or server threads found for the handle given as the argument to the function.

mysql_list_processes( )

This C API function returns a results set containing a list of MySQL server processes or server threads found for the handle given as the argument to the function.

mysql_list_tables( )

This C API function returns a results set containing a list of MySQL tables in the currently selected MySQL database.

mysql_list_tables( )

This C API function returns a results set containing a list of MySQL tables in the currently selected MySQL database.

mysql_more_results( )

Use this C API function to determine whether more results remain in a results set from MySQL when using the mysql_next_result() function to retrieve data.

Use this C API function to read the next row of data from a results set from MySQL.

mysql_num_fields( )

This C API function returns the number of fields in each row of a results set from MySQL.

mysql_num_fields( )

This C API function returns the number of fields in each row of a results set from MySQL.

mysql_num_rows( )

This C API function returns the number of rows in the results set from MySQL when issued after the mysql_store_result() function.

mysql_num_rows( )

This C API function returns the number of rows in the results set from MySQL when issued after the mysql_store_result() function.

mysql_ping( )

Use this C API function to determine whether the current MYSQL connection is still open.

mysql_ping( )

Use this C API function to determine whether the current MYSQL connection is still open.

mysql_query( )

Use this C API function to execute the MySQL query given.

mysql_query( )

Use this C API function to execute the MySQL query given.

Use this C API function to establish a connection to a MySQL server.

This C API function writes a string or MySQL column given to a string named, but with special characters escaped by adding backslashes in front of them.

mysql_real_escape_string( )

This C API function writes a string or MySQL column given to a string named, but with special characters escaped by adding backslashes in front of them.

Use this C API function to execute a MySQL query given.

Use this C API function to flush caches and tables in MySQL.

mysql_reload( )

This C API function instructs the MySQL server to reload the grants table.

mysql_rollback( )

Use this C API function to roll back or reverse the current transaction in MySQL.

mysql_row_seek( )

Use this C API function to move the pointer of a MySQL result set to the row given.

mysql_row_tell( )

This C API function returns the pointer for the current position in a results set from MySQL, generated from the mysql_store_result( ) function.

mysql_select_db( )

Use this C API function to select a different MySQL database for the current connection to MySQL.

mysql_select_db( )

Use this C API function to select a different MySQL database for the current connection to MySQL.

mysql_set_character_set( )

Use this C API function to set the default character set of a MySQL connection to the character set given.

mysql_set_local_infile_default( )

Use this C API function to set the handler for LOAD LOCAL DATA INFILE functions to the defaults necessary for internal use of the C client library when interacting with MySQL.

mysql_set_local_infile_handler( )

Use this C API function to enable callbacks that will be used with the LOAD DATA LOCAL INFILE statement in MySQL.

mysql_set_server_option( )

Use this C API function to enable or disable a MySQL server option.

mysql_shutdown( )

Use this C API function to shut down the MySQL server.

mysql_sqlstate( )

This C API function returns the SQLSTATE error code for the last error in MySQL that occurred for the current connection to MySQL.

mysql_ssl_set( )

This C API function is used to make a secure connection to MySQL with SSL.

mysql_stat( )

This C API function returns a character string containing information about the status of the MySQL server for the current connection.

mysql_stat( )

This C API function returns a character string containing information about the status of the MySQL server for the current connection.

mysql_store_result( )

Use this C API function to read and store all of a results set from MySQL in a MYSQL_RES structure.

mysql_thread_end( )

Use this C API function before calling to free memory used by mysql_thread_init( ) related to MySQL.

mysql_thread_id( )

This C API function returns the thread identifier number for the current connection to MySQL.

mysql_thread_id( )

This C API function returns the thread identifier number for the current connection to MySQL.

Use this C API function to initialize thread specific variables in MySQL.

mysql_thread_safe( )

Use this C API function to determine whether the MySQL client library is safe for a threaded environment.

Use this C API function to read the results of a MySQL query, one row at a time.

mysql_warning_count( )

This C API function returns the number of MySQL warning messages encountered from the previous query.