mysql_stmt_num_rows(3)

💖 mysql_stmt_num_rows 💖

okay bestie so this is a page from the MariaDB Connector/C manual, and today's main character is mysql_stmt_num_rows — she counts rows in a prepared statement result set. that's it, that's the job. and she EATS. 👑

✨ NAME ✨

mysql_stmt_num_rows — returns the number of rows in a prepared statement result set. no cap, that's literally her whole thing. 🎀

🌸 SYNOPSIS 🌸

#include <mysql.h>

unsigned long long mysql_stmt_num_rows(MYSQL_STMT * stmt);

look at that signature. clean. iconic. the way she returns an unsigned long long? feral. 💅

🦋 DESCRIPTION 🦋

so what does she actually do? she returns the number of rows in the result set. periodt.

but here's the tea, and this is the part you need to remember fr fr: how you use mysql_stmt_num_rows() depends on whether or not you used mysql_stmt_store_result(3) to buffer the entire result set in the statement handle. that's the whole vibe check. whether you buffered everything or not decides how this goes down. iykyk. 🌈

💜 PARAMETER 💜

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3). like, she's not gonna invent one for you, bestie, you gotta bring your own. 🫶

⭐ RETURN VALUE ⭐

the number of rows in the result set. that's it. that's the number. ✨

🎀 NOTES 🎀

• if you use mysql_stmt_store_result(3), then mysql_stmt_num_rows() may be called immediately. like, no waiting, no drama, she's ready the second you ask. obsessed. 💖

lowkey important: those two functions are besties. one buffers, the other counts. don't separate them and expect the same energy. 🙈

🧚 SEE ALSO 🧚

• mysql_stmt_store_result(3)

version 3.4, babes — straight out of the MariaDB Connector/C manual, and that's the whole page, mwah 💋✨ no notes, she ate, and honestly? we're all a little obsessed. 🍓💅👑