mysql_store_result(3)

🦋 mysql_store_result(3) — bestie edition 💅

ok so you're in the MariaDB Connector/C manual, and this page is literally the one about grabbing a whole buffered result set. no cap, it's a good one. 🎀

✨ NAME ✨

mysql_store_result — returns a buffered result set 💖

🌸 SYNOPSIS 🌸

#include <mysql.h>

MYSQL_RES * mysql_store_result(MYSQL * mysql);

👑 DESCRIPTION 👑

It returns a buffered resultset from the last query you executed. that's it, that's the whole vibe. ✨

💀 Notes 💀

• mysql_field_count() indicates if there will be a result set available. iykyk — check it before you assume there's anything to store. 🙈
• The memory allocated by mysql_store_result() needs to be released by calling the function mysql_free_result(3). do not forget this one, bestie, or you're leaking memory and the vibe check will fail. 😭

🫶 PARAMETERS 🫶

• mysql is a connection identifier, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). so like, it has to be a real live connection already, not a random pointer you found on the floor. 🌈

⭐ RETURN VALUE ⭐

Returns a buffered result set — or NULL in case an error occurred, or if the query didn't return data (e.g. when executing an INSERT, UPDATE, DELETE or REPLACE statement). so yeah, NULL here isn't always a disaster, sometimes your query just had nothing to say. 💀

🌈 SEE ALSO 🌈

• mysql_free_result(3)
• mysql_use_result(3)
• mysql_real_query(3)
• mysql_field_count(3)

and that's the whole page, periodt. 💜 this was MariaDB Connector/C, Version 3.4 — go forth and mysql_free_result your stuff, mwah 🎀✨