mysql_stmt_more_results(3)

✨ mysql_stmt_more_results 💅

okay so bestie, welcome to the MariaDB Connector/C manual, and today's main character is mysql_stmt_more_results — she's the one who tells you whether there are more result sets waiting for you from a prepared statement you already ran. yes, more. as in, plural. as in, the plot thickens. 🎀

🌸 Name

mysql_stmt_more_results — indicates if one or more results from a previously executed prepared statement are available

🦋 Synopsis

#include <mysql.h>

my_bool mysql_stmt_more_results(MYSQL_STMT * stmt);

💖 Description

She indicates if one or more result sets are available from a previous call to mysql_stmt_execute(3). that's it, that's the whole vibe check. ✨

🎀 Parameter

• stmt — a statement handle, which was previously allocated by mysql_stmt_init() and executed by mysql_stmt_execute(3). like, she's gotta be a real one who's already been through init and execute, no shortcuts bestie 🫶

👑 Notes

• Multiple result sets can be obtained by calling a stored procedure. yes, stored procs are that girl and they can hand you back a whole stack of result sets. 🌈
• Executing concatenated statements is not supported in prepared statement protocol. so don't try to be slick and smoosh multiple statements together in a prepared statement, because she will not play that game. 💀

⭐ Return value

Returns 1 if more result sets are available, otherwise zero. one means "there's more, keep going", zero means "that's a wrap, we're done here". periodt. 💅

🔥 See also

• mysql_stmt_next_result(3)
• mysql_stmt_store_result(3)

Version 3.4 of the MariaDB Connector/C manual, bestie — that's the whole page. go forth and fetch those extra result sets, you absolute icon. mwah 💖🌸🦋✨

mysql_stmt_more_results(3)