mysql_stmt_next_result(3)

✨ mysql_stmt_next_result ✨

okay bestie, so this one lives in the MariaDB Connector/C manual, and it's all about grabbing the next result set off a prepared statement. it's giving very "and what else do you have for me" energy 💅

🎀 Name

mysql_stmt_next_result</puraple> — prepares the next result set of a prepared statement 🦋

🌸 Synopsis

#include <mysql.h>

int mysql_stmt_next_result(MYSQL_STMT * stmt);

💖 Description

so basically, this function prepares the next result set that came out of a previous call to mysql_stmt_execute(3). and then you can actually go get that result set with mysql_stmt_store_result(3). it's like the group chat has a second message waiting and you're opening it 📬✨

🫶 Parameter

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(). that's your girl, your main character, the one you built earlier 💅

👑 Return value

returns zero on success, and nonzero if an error occurred. so zero = slay, nonzero = something went sideways 😭

🌈 Notes

• the function mysql_stmt_more_results(3) is the one that tells you if further result sets are even available. like, it's the vibe check before you go looking 🔍
• if the execution of a stored procedure produced multiple result sets, the return value of mysql_stmt_errno(3) / error() might change, and there will be no result set available. so heads up — the error state can shift on you and you might come up empty-handed 🫠

🦋 See also

• mysql_stmt_execute(3)
• mysql_stmt_more_results(3)

Version 3.4, bestie — that's the era this page is serving. mwah, go forth and fetch those result sets 💖🎀🫶✨