C-language MySQL API

Original: C language MySQL API

1.mysql_affected_rows ()//returns the number of rows that were changed/deleted/inserted by the last update, delete, or insert query.

2.mysql_autocommit ()//Toggle autocommit mode, ON/off.

3.mysql_change_user ()//change the users and databases on the open connection.

4.mysql_charset_name ()//returns the name of the default character set used for the connection.

5.mysql_close ()//Shut down the server connection.

6.mysql_commit ()//Commit the transaction.

7.mysql_data_seek ()//Find the attribute row number in the query result set.

8.mysql_debug ()//executes Dbug_push with the given string.

9.mysql_dump_debug_info ()//Let the server write debug information to the log.

10.mysql_errno ()//Returns the error number of the last called MySQL function.

11.mysql_escape_string ()//In order to be used in SQL statements, special characters are escaped.

12.mysql_fetch_field ()//returns the type of the next table field.

13.mysql_fetch_field_direct ()//given field number, returns the type of table field.

14.mysql_fetch_fields ()//Returns an array of all field structures.

15.mysql_fetch_lengths ()//returns the length of all columns in the current row.

16.mysql_fetch_row ()//Get the next row from the result set

17.mysql_field_seek ()//places the column cursor in the specified column.

18.mysql_field_count ()//returns the number of result columns for the last executed statement.

19.mysql_field_tell ()//returns the position of the field cursor used by the last Mysql_fetch_field ().

20.mysql_free_result ()//releases the memory used by the result set.

21.mysql_get_client_info ()//Returns the client version information as a string.

22.mysql_get_client_version ()//Returns the client version information as an integer.

23.mysql_get_host_info ()//Returns a string that describes the connection.

24.mysql_get_server_version ()//returns the version number of the server as an integer.

25.mysql_get_proto_info ()//Returns the protocol version used by the connection.

26.mysql_get_server_info ()//returns the version number of the server.

27.mysql_info ()//returns information about the most recently executed query.

28.mysql_init ()//Gets or initializes the MySQL structure.

29.MYSQL_INSERT_ID ()//returns the ID of the previous query that was generated for the Auto_increment column.

30.mysql_kill ()//kills the given thread.

31.mysql_library_end ()//Finalize the MySQL C API library.

32.mysql_library_init ()//initialize MySQL C API library.

33.mysql_list_dbs ()//returns the name of the database that matches the simple regular expression.

34.mysql_list_fields ()//returns the name of the field that matches the simple regular expression.

35.mysql_list_processes ()//Returns a list of current server threads.

36.mysql_list_tables ()//returns the name of the table that matches the simple regular expression.

37.mysql_more_results ()//check if there are any other results.

38.mysql_next_result ()//Returns/initializes the next result during multi-statement execution.

39.mysql_num_fields ()//Returns the number of columns in the result set.

40.mysql_num_rows ()//returns the number of rows in the result set.

41.mysql_options ()//Set connection options for mysql_connect ().

42.mysql_ping ()//check if the connection to the server is working, and reconnect if necessary.

43.mysql_query ()//executes the SQL query specified as a null-terminated string.

44.mysql_real_connect ()//Connect to the MySQL server.

45.mysql_real_escape_string ()//Considering the current character set of the connection, in order to be used in the SQL statement, the special characters in the string are escaped.

46.mysql_real_query ()//executes the SQL query specified as a count string.

47.mysql_refresh ()//refresh or reset table and high-speed buffering.

48.mysql_reload ()//notifies the server to load the authorization table again.

49.mysql_rollback ()//ROLLBACK TRANSACTION.

50.mysql_row_seek ()//Use the value returned from Mysql_row_tell () to find the row offset in the result set.

51.mysql_row_tell ()//returns the row cursor position.

52.mysql_select_db ()//Select database.


53.mysql_server_end ()//finalize the embedded server library.

54.mysql_server_init ()//Initialize the embedded server library.

55.mysql_set_server_option ()//SET options (such as multiple statements) for the connection.

56.mysql_sqlstate ()//returns the SQLSTATE error code for the previous error.
57.mysql_shutdown ()//Shut down the database server.
58.mysql_stat ()//returns the server state as a string.
59.mysql_store_result ()//Retrieve the complete result set to the client.
60.MYSQL_THREAD_ID ()//returns the current thread ID.
61.mysql_thread_safe ()//If the client has been compiled for thread-safe, return 1.
62.mysql_use_result ()//Initialize row-wise result set retrieval.
63.mysql_warning_count ()//returns the number of alarms for the previous SQL statement.

C-language MySQL API