OceanBase

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

Product Overview

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

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

mysql_stmt_row_seek() searches for an arbitrary row in the result set of a prepared statement.

Syntax

MYSQL_ROW_OFFSET
mysql_stmt_row_seek(MYSQL_STMT *stmt,
                    MYSQL_ROW_OFFSET offset)

The value of offset indicates the row offset that is returned by mysql_stmt_row_tell() or mysql_stmt_row_seek().

Return values

The previous value of the row cursor. The value can be used to call mysql_stmt_row_seek().

Error messages

None.

Notes

The value of offset is not a row number. If you want to find a row in the result set by number, use mysql_stmt_data_seek().

This function requires that the result set structure contains the entire result of the query. Therefore, you need to use mysql_stmt_row_seek() with mysql_stmt_store_result().

Previous topic

mysql_stmt_result_metadata()

Last

Next topic

mysql_stmt_row_tell()