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.

View All

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.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

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

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_close()

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

You can call the mysql_stmt_close() function to close a prepared statement.

Syntax

my_bool
mysql_stmt_close(MYSQL_STMT *stmt)

Return values

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

Errors

CR_SERVER_GONE_ERROR: The connection to the OBServer was disconnected.
CR_UNKNOWN_ERROR: An unknown error occurred.

Notes

mysql_stmt_close() deallocates the statement handler to which stmt points. At that point in time, the handler becomes invalid and should no longer be used.

For a failed mysql_stmt_close() call, do not call mysql_stmt_error(), or mysql_stmt_errno(), or mysql_stmt_sqlstate() to obtain error information because mysql_stmt_close() makes the statement handler invalid. Call mysql_error(), mysql_errno(), or mysql_sqlstate() instead.

If the current statement has pending or unread results, this function will cancel them so that the next query can be executed.

Previous topic

mysql_stmt_bind_result()

Last

Next topic

mysql_stmt_data_seek()