Full list of C language APIs for MySQL on Linux

1. mysql_affected_rows () // return the number of rows that were modified, deleted, or inserted in the last update, delete, or insert query.

2. mysql_autocommit () // switch the autocommit mode, ON/OFF.

3. mysql_change_user () // change the user and database on which the connection is opened.

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

5. mysql_close () // close the server connection.

6. mysql_commit () // submit the transaction.

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

8. mysql_debug () // execute dbug_push with the given string.

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

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

11. mysql_escape_string () // escape special characters for use in SQL statements.

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

13. mysql_fetch_field_direct () // specify the field number and return the type of the table field.

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

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

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

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

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

19. mysql_field_tell () // return the cursor position of the field used by the last mysql_fetch_field.

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

21. mysql_get_client_info () // return the Client Version Information in string format.

22. mysql_get_client_version () // return the Client Version Information in integer format.

23. mysql_get_host_info () // return the string that describes the connection.

24. mysql_get_server_version () // return the server version number in integer format.

25. mysql_get_proto_info () // return the Protocol Version Used for the connection.

26. mysql_get_server_info () // return the server version number.

27. mysql_info () // return information about the last query executed.

28. mysql_init () // obtain or initialize the MySQL structure.

29. mysql_insert_id () // return the ID generated in the previous query for the auto_increment column.

30. mysql_kill () // kill the specified thread.

31. mysql_library_end () // finally determine the MySQL C api library.

32. mysql_library_init () // initialize the MySQL C api library.

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

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

35. mysql_list_processes () // return the list of current server threads.

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

37. mysql_more_results () // check whether other results exist.

38. mysql_next_result () // return/initialize the next result during multi-statement execution.

39. mysql_num_fields () // Number of columns in the returned result set.

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

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

42. mysql_ping () // check whether the connection to the server is working and try again if necessary.

43. mysql_query () // execute an SQL query specified as a "null-terminated string.

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

45. mysql_real_escape_string () // considering the connected Character Set, escape special characters in the string for use in SQL statements.

46. mysql_real_query () // execute the SQL query specified as the Count string.

47. mysql_refresh () // refresh or reset the table and cache.

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

49. mysql_rollback () // roll back the 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 () // return the cursor position of the row.

52. mysql_select_db () // select a database.

53. mysql_server_end () // final determine the Embedded Server library.

54. mysql_server_init () // initialize the Embedded Server library.

55. mysql_set_server_option () // set the connection options (for example, multiple statements ).

56. mysql_sqlstate () // return the sqlstate error code about the previous error.
57. mysql_shutdown () // shut down the database server.
58. mysql_stat () // return the server status in string format.
59. mysql_store_result () // retrieve the complete result set to the client.
60. mysql_thread_id () // return the ID of the current thread.
61. mysql_thread_safe () // if the client has been compiled into thread-safe, return 1.
62. mysql_use_result () // initialize a row-by-row result set search.
63. mysql_warning_count () // returns the number of alarms for the previous SQL statement.