mysql_stmt_fetch_column(3)

✨ mysql_stmt_fetch_column — the MariaDB Connector/C glow-up 💅

okay bestie, quick vibe check: this is a page from the MariaDB Connector/C manual, and we're talking about mysql_stmt_fetch_column. it's giving ✨precision snacking✨ — you don't have to eat the whole column in one bite.

🎀 NAME 🎀

mysql_stmt_fetch_column — fetches a single column into a bind buffer 🫶

🦋 SYNOPSIS 🦋

#include <mysql.h>

int mysql_stmt_fetch_column(MYSQL_STMT * stmt,
                            MYSQL_BIND * bind_arg,
                            unsigned int column,
                            unsigned long offset);

🌸 DESCRIPTION 🌸

so like. sometimes a column is huge. like, unreasonably big. and this function is the answer to that, no cap: you can use mysql_stmt_fetch_column to fetch large data of a single column in pieces. little bites. tiny sips. one chunk at a time, on your terms 💖

🌈 PARAMETER 🌈

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3). your main character, basically 👑
• bind_arg — a pointer to a MYSQL_BIND structure.
• column — number of column, first column is numbered zero. yes bestie, zero-indexed, we start counting at 0 💀
• offset — offset at which to begin retrieving data.

⭐ RETURN VALUE ⭐

Returns zero on success, non-zero on failure. that's it, that's the tea 🍓

💜 NOTES 💜

• The size of the buffer is specified within MYSQL_BIND structure. so like, the MYSQL_BIND is holding the bag on how much room you've got 🎀

🔥 SEE ALSO 🔥

• mysql_stmt_fetch(3)
• mysql_stmt_send_long_data(3)

and that's a wrap, bestie!! this was Version 3.4 of the MariaDB Connector/C manual, mysql_stmt_fetch_column(3) — go forth and fetch in pieces, you icon 💅✨🦋