Sign In

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

OceanBase Connector/C

V2.0.0

Overview
Installation guide
User Guide
- Basic data structures
- Basic operations
  - Basic API operations
  - API operations on prepared statements
C API functions
- Overview
- my_init()
- mysql_affected_rows()
- mysql_autocommit()
- mysql_change_user()
- mysql_character_set_name()
- mysql_client_find_plugin()
- mysql_client_register_plugin()
- mysql_close()
- mysql_commit()
- mysql_connect()
- mysql_create_db()
- mysql_data_seek()
- mysql_debug()
- mysql_drop_db()
- mysql_dump_debug_info()
- mysql_eof()
- mysql_errno()
- mysql_error()
- mysql_escape_string()
- mysql_fetch_field()
- mysql_fetch_field_direct()
- mysql_fetch_fields()
- mysql_fetch_lengths()
- mysql_fetch_row()
- mysql_field_count()
- mysql_field_seek()
- mysql_field_tell()
- mysql_free_result()
- mysql_get_character_set_info()
- mysql_get_client_info()
- mysql_get_client_version()
- mysql_get_host_info()
- mysql_get_proto_info()
- mysql_get_server_info()
- mysql_get_server_version()
- mysql_get_ssl_cipher()
- mysql_hex_string()
- mysql_info()
- mysql_init()
- mysql_insert_id()
- mysql_kill()
- mysql_library_end()
- mysql_library_init()
- mysql_list_dbs()
- mysql_list_fields()
- mysql_list_processes()
- mysql_list_tables()
- mysql_load_plugin()
- mysql_load_plugin_v()
- mysql_more_results()
- mysql_next_result()
- mysql_num_fields()
- mysql_num_rows()
- mysql_options()
- mysql_options4()
- mysql_ping()
- mysql_plugin_options()
- mysql_query()
- mysql_real_connect()
- mysql_real_escape_string()
- mysql_real_query()
- mysql_refresh()
- mysql_reload()
- mysql_rollback()
- mysql_row_seek()
- mysql_row_tell()
- mysql_select_db()
- mysql_server_end()
- mysql_server_init()
- mysql_set_character_set()
- mysql_set_local_infile_default()
- mysql_set_local_infile_handler()
- mysql_set_server_option()
- mysql_shutdown()
- mysql_sqlstate()
- mysql_ssl_set()
- mysql_stat()
- mysql_stmt_affected_rows()
- mysql_stmt_attr_get()
- mysql_stmt_attr_set()
- mysql_stmt_bind_param()
- mysql_stmt_bind_result()
- mysql_stmt_close()
- mysql_stmt_data_seek()
- mysql_stmt_errno()
- mysql_stmt_error()
- mysql_stmt_execute()
- mysql_stmt_fetch()
- mysql_stmt_fetch_column()
- mysql_stmt_field_count()
- mysql_stmt_free_result()
- mysql_stmt_init()
- mysql_stmt_insert_id()
- mysql_stmt_next_result()
- mysql_stmt_num_rows()
- mysql_stmt_param_count()
- mysql_stmt_param_metadata()
- mysql_stmt_prepare()
- mysql_stmt_reset()
- mysql_stmt_result_metadata()
- mysql_stmt_row_seek()
- mysql_stmt_row_tell()
- mysql_stmt_send_long_data()
- mysql_stmt_sqlstate()
- mysql_stmt_store_result()
- mysql_store_result()
- mysql_thread_end()
- mysql_thread_id()
- mysql_thread_init()
- mysql_thread_safe()
- mysql_use_result()
- mysql_warning_count()

Download PDF

Document Feedback

mysql_stmt_bind_result()

Last Updated：2026-04-10 03:06:40 Updated

share

share

You can call the mysql_stmt_bind_result() function to associate or bind output columns in a result set to data buffers and length buffers.

Syntax

my_bool
mysql_stmt_bind_result(MYSQL_STMT *stmt,
                       MYSQL_BIND *bind)

bind is the address of an array of MYSQL_BIND structures.

Return values

0 is returned for an execution success, and a non-zero value is returned if an error occurred.

Errors

CR_UNSUPPORTED_PARAM_TYPE: The conversion is not supported. Maybe the buffer_type value is invalid or the type is not supported.
CR_OUT_OF_MEMORY: The memory is insufficient.
CR_UNKNOWN_ERROR: An unknown error occurred.

Notes

When mysql_stmt_fetch() is called to fetch data, the OceanBase client/server protocol places the data for the bound columns into the specified buffers. Before mysql_stmt_fetch() is called, all columns must be bound to buffers.

The client library expects the array to contain one element for each column of the result set. If a column is not bound to a MYSQL_BIND structure, mysql_stmt_fetch() ignores this column during data fetch.

A column can be bound or rebound at any time, even after a result set is partially retrieved. The new binding takes effect the next time when mysql_stmt_fetch() is called. Assume that an application binds the columns in a result set and calls mysql_stmt_fetch(). The client/server protocol returns data in the bound buffers. Then, assume that the application binds the columns to a different set of buffers. The protocol places data into the newly bound buffers the next time when mysql_stmt_fetch() is called.

To bind a column, the application calls mysql_stmt_bind_result() and passes the type, address, and length of the output buffer.

Previous topic

mysql_stmt_bind_param()

Next topic

mysql_stmt_close()