How do you execute an INSERT statement using MySQL (in c++)?

Question

Google is failing me (or I am failing Google.)

I am simply looking for the function that executes an INSERT statement using the mysql.h library in C++.

Answer 1

Not too familiar with using MySQL in C, but according to what I can see in the mysql.h file, you should call mysql_stmt_prepare to create the statement, and mysql_stmt_execute to execute said prepared statement.

Answer 2

I've got some mysql wrapper code that you can use for reference, just look at the function called kGUIDBRecord::Save on the page

http://code.google.com/p/kgui/source/browse/trunk/kguidb.cpp

Answer 3

Have you tried MySQL++?

http://tangentsoft.net/mysql++/