mysql_fetch_field(3)

💖 NAME 💖

mysql_fetch_field — bestie, this one hands you the definition of exactly one column of a result set. One. At a time. We're doing this slowly and we're doing it right. ✨

🌸 SYNOPSIS 🌸

#include <mysql.h>

MYSQL_FIELD * mysql_fetch_field(MYSQL_RES * result);

🦋 DESCRIPTION 🦋

Okay so picture this: you got a result set, and you wanna know what's in it — like, what are these columns, who are they, what's their whole deal. mysql_fetch_field gives you the definition of one column of that result set, and it gives it to you as a pointer to a MYSQL_FIELD structure. 🌈

And the way you use it? You literally just call it over and over again, and each call serves you the next column's info, until you've collected the whole set. It's giving "one fry at a time" energy and honestly? We respect the process. 🍓

🎀 PARAMETERS 🎀

• result — a result set identifier, and it has to be one you got back from mysql_store_result(3) or mysql_use_result(3). No random pointers, bestie, we need the real thing. 💅

👑 NOTES 👑

• The field order will be reset if you execute a new SELECT query. So like, if you start a fresh SELECT, don't expect to pick up where you left off — the lineup gets shuffled back to the start. 😭
• If you only need the info for one specific field, don't sit there looping like a main character with too much free time. You can select that field directly with the mysql_field_seek(3) function, or just grab it with mysql_fetch_field_direct(3). Efficient queen behavior. 💖

✨ RETURN VALUE ✨

A pointer to a MYSQL_FIELD structure. 🫶

Or NULL if there are no more fields left — that's your lil signal that you've reached the end of the lineup, so stop calling it, it has nothing left to give you. 💀

🔥 SEE ALSO 🔥

• mysql_field_seek(3)
• mysql_field_tell(3)
• mysql_fetch_field_direct(3)
• mysql_store_result(3)
• mysql_use_result(3)

And that's the whole page, periodt. 💜 This was Version 3.4 of the MariaDB Connector/C manual, and yeah — the footer said mysql_fetch_field(3) too, we're just folding that in here so you know exactly which page you're on. Go forth and fetch those fields, icon. 🧚