mysql_warning_count(3)

✨ mysql_warning_count ✨

okay so bestie, we're in the MariaDB Connector/C section of the manual, and today's main character is mysql_warning_count — she's lowkey one of the most useful little functions you'll ever meet, no cap 💅

🌸 Name 🌸

mysql_warning_count — returns the number of warnings 🫶

🎀 Synopsis 🎀

#include <mysql.h>

unsigned int mysql_warning_count(MYSQL * mysql);

🦋 Description 🦋

So here's the vibe: she gives you back the number of warnings that came from the last executed query. That's it, that's the whole job. If there were no warnings at all? She hands you a zero and minds her business. ✨

💖 Parameter 💖

• mysql — a mysql handle 🫶 and like, it has to be one that was already allocated by mysql_init(3) and then connected by mysql_real_connect(3). No random uninitialized handles, babe, that's not the move 🙈

⭐ Notes ⭐

• Wanna actually read those warning messages, not just count them? You gotta use the SQL command SHOW WARNINGS. Counting is one thing, reading the receipts is another 📜
• And listen — if SQL_MODE TRADITIONAL is enabled, you get an error instead of a warning. Yes, really. For the detailed tea, go check the server documentation 👑

🌈 Return value 🌈

Returns the number of warnings ✨

💜 See also 💜

• mysql_error(3)
• mysql_errno(3)

and that's the whole page, bestie 🎀 shoutout to Version 3.4 of the MariaDB Connector/C manual for bringing us this icon — she ate and left no crumbs, periodt 💅✨🦋