mysql_row_seek(3)

💫 mysql_row_seek — bestie, let's teleport that cursor

okay so this is a page from the MariaDB Connector/C manual, and we're talking about mysql_row_seek(3) — the function that yeets your row cursor to whatever row you want. no cap. 🦋

✨ Name ✨

mysql_row_seek — positions the row cursor to an arbitrary row. literally just "jump to row, you pick which one". main character energy fr. 👑

🌸 Synopsis 🌸

#include <mysql.h>

MYSQL_ROW_OFFSET mysql_row_seek(MYSQL_RES * result,
                                MYSQL_ROW_OFFSET offset);

that's the whole vibe. include the header, call the function, get a MYSQL_ROW_OFFSET back. periodt. 💅

💖 Description 💖

so like, mysql_row_seek positions the row cursor to an arbitrary row in a result set — but hear me out, bestie, it only works on a result set that was obtained by mysql_store_result(3). that's the whole thing. that's the function. it's giving "fast travel unlocked". ✨

🎀 Parameter 🎀

• result — a result set identifier, and it's the one returned by mysql_store_result(3). no substitutions, she's specific. 🙈
• offset — the row offset. you can get this value from either mysql_row_seek() or mysql_row_tell(3). so you can save a spot and come back to it later, iconic behaviour honestly. 📌

🦋 Notes 🦋

• This function will not work if the result set was obtained by mysql_use_result(3). like, at all. don't try it. it's giving "wrong door, babe". 💀

⭐ Return value ⭐

Returns the previous row offset. so it tells you where you were while it moves you to where you wanna be. very "here's your receipt, enjoy your new row" of it. 🧾✨

🌈 See also 🌈

• mysql_store_result(3)
• mysql_row_tell(3)

and that's the page, bestie!! 💜 this was pulled straight from the MariaDB Connector/C docs, Version 3.4 — so if you're out here seeking rows like the icon you are, you're on the right version. mwah. 💋🎀🫶