9 MySQL APIs

This chapter describes the APIs available for MySQL, where to get them, and how to use them. The C API is the most extensively covered, as it was developed by the MySQL team, and is the basis for most of the other APIs.

Subsections

• 9.1 MySQL C API
• 9.1.1 C API Datatypes
• 9.1.2 C API Function Overview
• 9.1.3 C API Function Descriptions
• 9.1.3.1 mysql_affected_rows()
• 9.1.3.2 mysql_change_user()
• 9.1.3.3 mysql_character_set_name()
• 9.1.3.4 mysql_close()
• 9.1.3.5 mysql_connect()
• 9.1.3.6 mysql_create_db()
• 9.1.3.7 mysql_data_seek()
• 9.1.3.8 mysql_debug()
• 9.1.3.9 mysql_drop_db()
• 9.1.3.10 mysql_dump_debug_info()
• 9.1.3.11 mysql_eof()
• 9.1.3.12 mysql_errno()
• 9.1.3.13 mysql_error()
• 9.1.3.14 mysql_escape_string()
• 9.1.3.15 mysql_fetch_field()
• 9.1.3.16 mysql_fetch_fields()
• 9.1.3.17 mysql_fetch_field_direct()
• 9.1.3.18 mysql_fetch_lengths()
• 9.1.3.19 mysql_fetch_row()
• 9.1.3.20 mysql_field_count()
• 9.1.3.21 mysql_field_seek()
• 9.1.3.22 mysql_field_tell()
• 9.1.3.23 mysql_free_result()
• 9.1.3.24 mysql_get_client_info()
• 9.1.3.25 mysql_get_server_version()
• 9.1.3.26 mysql_get_host_info()
• 9.1.3.27 mysql_get_proto_info()
• 9.1.3.28 mysql_get_server_info()
• 9.1.3.29 mysql_info()
• 9.1.3.30 mysql_init()
• 9.1.3.31 mysql_insert_id()
• 9.1.3.32 mysql_kill()
• 9.1.3.33 mysql_list_dbs()
• 9.1.3.34 mysql_list_fields()
• 9.1.3.35 mysql_list_processes()
• 9.1.3.36 mysql_list_tables()
• 9.1.3.37 mysql_num_fields()
• 9.1.3.38 mysql_num_rows()
• 9.1.3.39 mysql_options()
• 9.1.3.40 mysql_ping()
• 9.1.3.41 mysql_query()
• 9.1.3.42 mysql_real_connect()
• 9.1.3.43 mysql_real_escape_string()
• 9.1.3.44 mysql_real_query()
• 9.1.3.45 mysql_reload()
• 9.1.3.46 mysql_row_seek()
• 9.1.3.47 mysql_row_tell()
• 9.1.3.48 mysql_select_db()
• 9.1.3.49 mysql_sqlstate()
• 9.1.3.50 mysql_shutdown()
• 9.1.3.51 mysql_stat()
• 9.1.3.52 mysql_store_result()
• 9.1.3.53 mysql_thread_id()
• 9.1.3.54 mysql_use_result()
• 9.1.3.55 mysql_commit()
• 9.1.3.56 mysql_rollback()
• 9.1.3.57 mysql_autocommit()
• 9.1.3.58 mysql_more_results()
• 9.1.3.59 mysql_next_result()
• 9.1.4 C API Prepared Statements
• 9.1.5 C API Prepared Statement Datatypes
• 9.1.6 C API Prepared Statement Function Overview
• 9.1.7 C API Prepared Statement Function Descriptions
• 9.1.7.1 mysql_prepare()
• 9.1.7.2 mysql_param_count()
• 9.1.7.3 mysql_prepare_result()
• 9.1.7.4 mysql_bind_param()
• 9.1.7.5 mysql_execute()
• 9.1.7.6 mysql_stmt_affected_rows()
• 9.1.7.7 mysql_bind_result()
• 9.1.7.8 mysql_stmt_store_result()
• 9.1.7.9 mysql_stmt_data_seek()
• 9.1.7.10 mysql_stmt_row_seek()
• 9.1.7.11 mysql_stmt_row_tell()
• 9.1.7.12 mysql_stmt_num_rows()
• 9.1.7.13 mysql_fetch()
• 9.1.7.14 mysql_send_long_data()
• 9.1.7.15 mysql_stmt_close()
• 9.1.7.16 mysql_stmt_errno()
• 9.1.7.17 mysql_stmt_error()
• 9.1.7.18 mysql_stmt_sqlstate()
• 9.1.8 C API Handling of Multiple Query Execution
• 9.1.9 C API Handling of Date and Time Values
• 9.1.10 C API Threaded Function Descriptions
• 9.1.10.1 my_init()
• 9.1.10.2 mysql_thread_init()
• 9.1.10.3 mysql_thread_end()
• 9.1.10.4 mysql_thread_safe()
• 9.1.11 C API Embedded Server Function Descriptions
• 9.1.11.1 mysql_server_init()
• 9.1.11.2 mysql_server_end()
• 9.1.12 Common questions and problems when using the C API
• 9.1.12.1 Why Is It that After mysql_query() Returns Success, mysql_store_result() Sometimes Returns NULL?
• 9.1.12.2 What Results Can I Get From a Query?
• 9.1.12.3 How Can I Get the Unique ID for the Last Inserted Row?
• 9.1.12.4 Problems Linking with the C API
• 9.1.13 Building Client Programs
• 9.1.14 How to Make a Threaded Client
• 9.1.15 libmysqld, the Embedded MySQL Server Library
• 9.1.15.1 Overview of the Embedded MySQL Server Library
• 9.1.15.2 Compiling Programs with libmysqld
• 9.1.15.3 Restrictions when using the Embedded MySQL Server
• 9.1.15.4 Using Option Files with the Embedded Server
• 9.1.15.5 Things left to do in Embedded Server (TODO)
• 9.1.15.6 A Simple Embedded Server Example
• 9.1.15.7 Licensing the Embedded Server
• 9.2 MySQL ODBC Support
• 9.2.1 How To Install MyODBC
• 9.2.2 How to Fill in the Various Fields in the ODBC Administrator Program
• 9.2.3 Connect parameters for MyODBC
• 9.2.4 How to Report Problems with MyODBC
• 9.2.5 Programs Known to Work with MyODBC
• 9.2.6 How to Get the Value of an AUTO_INCREMENT Column in ODBC
• 9.2.7 Reporting Problems with MyODBC
• 9.3 MySQL Java Connectivity (JDBC)
• 9.4 MySQL PHP API
• 9.4.1 Common Problems with MySQL and PHP
• 9.5 MySQL Perl API
• 9.5.1 DBI with DBD::mysql
• 9.5.2 The DBI Interface
• 9.5.3 More DBI/DBD Information
• 9.6 MySQL C++ API
• 9.6.1 Borland C++
• 9.7 MySQL Python API
• 9.8 MySQL Tcl API
• 9.9 MySQL Eiffel Wrapper

User Comments

Drivers for various Smalltalk implementations are available as well. http://swiki.squeakfoundation.org/gst/6 seems to have pointers to most of them.

Add your own comment.