mysql_stmt_result_metadata(3)

💖 NAME 💖

okay bestie, welcome to the MariaDB Connector/C manual page for mysql_stmt_result_metadata(3) — and yes, it does exactly what it says on the tin: it returns result set metadata from a prepared statement. iconic behavior, honestly. 🎀

📜 SYNOPSIS 📜

#include <mysql.h>

MYSQL_RES * mysql_stmt_result_metadata(MYSQL_STMT * stmt);

🌸 DESCRIPTION 🌸

so here's the tea: if you pass a statement to mysql_stmt_prepare(3) and that statement is one that produces a result set, then mysql_stmt_result_metadata() hands you back the result set you need to process the meta info. we're talking total number of fields and individual field information. it's giving backstage pass to the metadata, no rows invited. 💅

🫶 PARAMETER 🫶

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3). don't just roll up with any old pointer, bestie, it has to be one that mysql_stmt_init(3) already set you up with. ✨

👑 RETURN VALUE 👑

Returns a result set that can be used to process metadata information. that's it, that's the whole gift. 🎁

💀 NOTES 💀

• The result set returned by mysql_stmt_result_metadata() contains only metadata. It does not contain any row results. The rows are obtained by mysql_stmt_fetch(3). so don't go looking for actual data in there, it's not that kind of party. 🙈
• This result set pointer can be passed as an argument to any of the field-based functions that process result set metadata, such as: mysql_num_fields(3), mysql_fetch_field(3), mysql_fetch_field_direct(3), mysql_fetch_fields(3), mysql_field_count(3), mysql_field_seek(3), mysql_field_tell(3), mysql_free_result(3). literally a whole friend group of metadata functions, and this pointer is the group chat. 🫶

🌈 SEE ALSO 🌈

• mariadb_stmt_fetch_fields(3)
• mysql_free_result(3)
• mysql_stmt_prepare(3)

Version 3.4 of the MariaDB Connector/C manual, no date on the page but the vibe is timeless. that's the whole page, bestie — now go process that metadata and slay. 💖✨🎀🦋🌸💅🫶😭🔥👑🌈⭐💀🙈🍓🧚💜