C++ programmer needs n00b info on programming MySql from C/C++

Question

I need to get up to speed really quickly on programatically creating an manipulating a MySql database from C or C++. The d/b might be on the same machine, or might be remote.

is there a "definitive" book I can read (maybe O'Reilly?), or a great tutorial website?

Thanks,

~mawg();

Answer 1

Also, http://tangentsoft.net/mysql++/doc/

Answer 2

If Qt is an option for you, Trolltech ships good documentation for the QSql module. http://doc.trolltech.com/4.6/sql-programming.html

Answer 3

Have you looked at the official MySQL documentation. It sounds like you need to check out documentation on connectors.

Answer 4

You need to look up the connectors API documentation, as has already been suggested. You should be upto speed with accessing MySQL from C, in no time (if you know decent C), since the C API is the native API provided by MySQL server. Please take a look at the C API documentation.

Answer 5

I have used MySQL++ in the past for my university project. After the initial learning curve, I really got on with it and had a pretty good experience with it.

I'd probably recommend it seeing as it is uses a familiar OOP approach, and I found the connectors API ridiculously vague and obscure (but then again I'm not very read up on C)

Answer 6

If you want some c++ code to look at I've written a few class wrappers for interacting with mysql, they are here:

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