mysql_stmt_execute(3)

💅 mysql_stmt_execute 💅

okay bestie, welcome to the MariaDB Connector/C manual, page for mysql_stmt_execute. this one's a baddie, let's get into it 🎀

✨ Name ✨

mysql_stmt_execute — runs a prepared statement. like, actually sends it. the moment of truth. main character energy ✨

🌸 Synopsis 🌸

#include <mysql.h>

int mysql_stmt_execute(MYSQL_STMT * stmt);

🦋 Description 🦋

so basically: this function executes a prepared statement that you already prepared earlier with mysql_stmt_prepare(3). think of prepare as "getting ready" and execute as "okay GO 🏃♀️💨".

and here's the cute part — when it executes, any parameter markers that exist get automatically replaced with the appropriate data. no cap, it just does it for you. you don't have to do the swap yourself, it handles the whole vibe.

🍓 Parameter 🍓

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3). yes, the handle from init. the origin story matters, bestie.

💖 Return value 💖

Returns zero on success, non-zero on failure.

so like… 0 is the slay outcome. anything else means something went sideways and you should go check. 💀

👑 Notes 👑

• If the statement is UPDATE, REPLACE, DELETE or INSERT, the total number of affected rows can be determined by using the mysql_stmt_affected_rows(3) function. Likewise, if the query yields a result set the mysql_stmt_fetch(3) function is used.

so: affected-rows vibes → mysql_stmt_affected_rows(3). result-set vibes → mysql_stmt_fetch(3). know which one you're in, iykyk 🔥

🌈 See Also 🌈

• mariadb_stmt_execute_direct(3)
• mysql_stmt_prepare(3)
• mysql_stmt_bind_param(3)

and that's the whole page, bestie 🫶 this was the MariaDB Connector/C manual, mysql_stmt_execute(3), Version 3.4. go execute something iconic 💅✨🧚