What library is best for mysql-C++ programming?
I guess the official MySQL C++ library should do the job fairly well. http://dev.mysql.com/doc/refman/5.1/en/connector-cpp.html
I might be biased, since I'm the maintainer of MySQL++, but I think MySQL++ is best. :) Traffic on our mailing list is higher than on Connector/C++, and the library's about 10 years older, so is more functional. (Though possibly a bit cruftier.)
SOCI - there is absolutely nothing better written in C++ for C++ users writing C++.
Pretty much all the other libraries I've seen out there are as if the developers of the libraries have come from the java or c# world and tried dismally to bring those same concepts to C++, without even considering what C++ has to offer.
Though not "mySQL" sqlight is a tight little database which has c++ libraries. I bring this up because the question doesn't go into much detail and the alternative to requiring mySQL be installed on the machine may be desired.