mysql_stmt_row_seek(3)

💖 NAME 💖

mysql_stmt_row_seek — positions row cursor. fr fr, that's the whole vibe.

okay bestie, real talk: this page is from the MariaDB Connector/C manual, and it's all about moving your row cursor around like it's a little cursor on a map. let's get into it ✨

✨ SYNOPSIS ✨

#include <mysql.h>

MYSQL_ROW_OFFSET mysql_stmt_row_seek(MYSQL_STMT * stmt,
                                     MYSQL_ROW_OFFSET offset);

not me showing you the exact signature, periodt. 💅

🌼 DESCRIPTION 🌼

Positions the row cursor to an arbitrary row in a result set which was obtained by mysql_stmt_store_result(3).

it's giving "teleport but for rows" — you pick a row, the cursor goes there. iconic behavior honestly. 🦋

🎀 PARAMETER 🎀

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3).
• offset — row offset. This value can be obtained either by mysql_stmt_row_seek() or mysql_stmt_row_tell(3).

two params, zero drama, we love to see it. 🌸

💫 RETURN VALUE 💫

Returns the previous row offset.

so it's like, "here's where you were before, bestie." keep that receipt. 🧾✨

⚠️ NOTES ⚠️

The result set must be obtained by mysql_use_result(3).

okay this is important — read it twice. the result set has to come from mysql_use_result(3) for this to work, no cap. 😭💀

👑 SEE ALSO 👑

• mysql_stmt_row_tell(3)
• mysql_stmt_store_result(3)

go read these next, iykyk. 🫶

and that's the page, bestie. this was Version 3.4 of the MariaDB Connector/C manual, for mysql_stmt_row_seek(3) — mwah, love u, bye 💋🎀💖