mysql_next_result(3)

💫 mysql_next_result — bestie, go get the NEXT result set

okay so real quick: this page lives in the MariaDB Connector/C manual (section 3, the library calls, iykyk). Let's get into it 🌸

🎀 Name

mysql_next_result — prepares next result set ✨

🦋 Synopsis

#include <mysql.h>

int mysql_next_result(MYSQL * mysql);

💅 Description

so basically 👑 — this one prepares the next result set from a previous call to mysql_real_query(3). and like, you then actually grab that result set with mysql_store_result(3) or mysql_use_result(3). the way it works is: returns zero on success, and nonzero if an error occurred. that's it, that's the whole vibe 💖

🍓 Parameter

• mysql — a mysql handle 🫶 which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). like, it has to be a real, live, connected handle bestie, no fake ones 💀

✨ Notes

• 🚨 if a multi query contains errors, the return value of mysql_errno(3) and mysql_error(3) might change, and there will be no result set available. so like, don't be out here assuming there's a result waiting for you — because there is not 🙈

👑 Return value

Returns zero on success, non zero value on error. periodt 💅

🌈 See also

• mysql_real_query(3)
• mysql_store_result(3)
• mysql_use_result(3)
• mysql_more_results(3)

mwah 💜 that's the whole page, you ate it, no crumbs. this was Version 3.4 of the MariaDB Connector/C manual — go forth and loop those result sets like the icon you are 🧚✨