mysql_field_seek(3)

✨ mysql_field_seek ✨

okay bestie, welcome to the MariaDB Connector/C manual, section 3 🎀 this one's about mysql_field_seek and it's literally the "jump to that column, bestie" function, no cap.

🌸 Name 🌸

mysql_field_seek — sets the field cursor to given offset 💅

🦋 Synopsis 🦋

#include <mysql.h>

MYSQL_FIELD_OFFSET mysql_field_seek(MYSQL_RES * result,
                                    MYSQL_FIELD_OFFSET offset);

💖 Description 💖

So here's the vibe: mysql_field_seek sets the field cursor to the given offset. That's it, that's the whole job, and it ate. 👑

And the payoff? The next call to mysql_fetch_field(3) will retrieve the field definition of the column associated with that offset. So you're basically telling the cursor "girl, go stand over there" and then the next fetch serves you exactly that column's field definition. iconic behaviour honestly 🌟

🎀 Parameters 🎀

• result — a result set identifier returned by mysql_store_result(3) or mysql_use_result(3). it's the whole result set babe, you gotta hand it over 🫶
• offset — the field number. and listen, this number must be in the range from 0..number of fields - 1. color inside the lines or it's giving chaos 😭

💅 Notes 💅

• The number of fields can be obtained from mysql_field_count(3). use it, bestie, don't guess 💀
• To move the field cursor to the first field, the offset parameter should be zero. first field, zero offset, that's the rule 🌈

⭐ Return value ⭐

Returns the previous value of the field cursor. yes, the old one, not the new one — she remembers where you were before you moved, and that's on main character energy 👑

🔥 See also 🔥

• mysql_field_tell(3) — the other half of this duo, go say hi 🍓

Version 3.4 of the MariaDB Connector/C man pages, and that's a wrap bestie 💜 mwah, go forth and seek those fields, you absolute Unix icon 🧚✨