mysql_real_query(3)

💖 Name 💖

okay so bestie, this is mysql_real_query(3) — MariaDB Connector/C edition, and she's here to execute a statement on the database server. Binary safe, no cap. 💅

✨ Synopsis ✨

              #include <mysql.h>

              int mysql_real_query(MYSQL * mysql,
                                   const char * query,
                                   unsigned long length);

🌸 Description 🌸

mysql_real_query() is the binary safe function for performing a statement on the database server. It's giving "I can handle your query, bestie" energy. 💖

🎀 Parameter 🎀

• mysql — a mysql handle, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). Like, she needs to be initialized and connected first, periodt.
• query — a string containing the statement to be performed. Your actual query goes here, and it's literally the main character.
• length — length of the string. Yes, you have to tell her how long query is. Slay.

🦋 Notes 🦋

• Contrary to the mysql_query(3) function, mysql_real_query is binary safe. That's the whole point, bestie — she doesn't flinch at binary data. 💅
• To determine if mysql_real_query returns a result set use the mysql_num_fields(3) function. So if you're wondering "did I get a result set or not?", mysql_num_fields(3) is your girl. 🫶

💅 Return value 💅

Returns zero on success, otherwise non zero. So zero = she ate, non zero = something's off. 👑

👑 See also 👑

• mysql_query(3)
• mysql_num_fields(3)
• mysql_use_result(3)
• mysql_store_result(3)

okay that's the whole vibe, bestie. MariaDB Connector/C, Version 3.4, mysql_real_query(3) — she's iconic, she's binary safe, and she's out. 💖✨🎀🦋🌸💅🫶👑🌈⭐