mysql_stmt_insert_id(3)

mysql_stmt_insert_id 💖✨

okay bestie, so we're in the MariaDB Connector/C manual, and today's main character is mysql_stmt_insert_id — she's the one who tells you what ID the database just made up for you. no cap.

✨ NAME ✨

mysql_stmt_insert_id — returns the auto generated id from a previously executed prepared statement. she's giving "who am I" but for rows. 💅

🌸 SYNOPSIS 🌸

#include <mysql.h>

my_ulonglong mysql_stmt_insert_id(MYSQL_STMT * stmt);

🦋 DESCRIPTION 🦋

so mysql_stmt_insert_id() hands you back the ID that was generated by a prepared statement, on a table that has a column with the AUTO_INCREMENT attribute. literally the "ooh what number did I get" function. 🔥

Parameter

• stmt — a statement handle, which was previously allocated by mysql_stmt_init(3). don't just make one up out of thin air, she needs to already exist fr fr. 🫶

Return value

returns the auto generated id from a previously executed prepared statement.

and here's the plot twist 😭 — if the last query wasn't an INSERT or UPDATE statement, or if the modified table does not have a column with the AUTO_INCREMENT attribute, this function will return zero. so a zero is not "no thoughts head empty", it's "nothing got auto-generated, babe". 💀

🎀 NOTES 🎀

• when you're doing a multi insert prepared statement, mysql_stmt_insert_id() will return the value of the first row. yes, just the first one. the rest are on their own. 🙈

👑 SEE ALSO 👑

• mysql_insert_id(3)

not me being obsessed with auto-increment IDs at this hour... but honestly? iconic. ⭐

and that's the whole page, bestie — slay 💖 this was the mysql_stmt_insert_id(3) page, part of the MariaDB Connector/C docs, Version 3.4. mwah, go insert something. 🎀✨🦋