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

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

You can call the mysql_stmt_data_seek() function to search for an arbitrary row in the result set of a statement.

Syntax

void
mysql_stmt_data_seek(MYSQL_STMT *stmt,
                     my_ulonglong offset)

The offset value is a row number and should range from 0 to mysql_stmt_num_rows(stmt)-1.

Return values

None.

Errors

None.

Notes

This function requires that the result set structure contain the entire result of the last executed query. In this way, mysql_stmt_data_seek() may be used only together with mysql_stmt_store_result().

Previous topic

mysql_stmt_close()

Last

Next topic

mysql_stmt_errno()