Mysql++

mysqlpp::Connection dbconnection;
dbconnection.connect("database", "server", "user", "passwd");

mysqlpp::Query prepared_query = dbconnect.query("SELECT * FROM  `my_table` ");
mysqlpp::StoreQueryResult r = prepared_query.store();

int field = r.field_num("columntobefetched");

for(mysqlpp::StoreQueryResult::iterator i=r.begin(); i!=r.end(); i++)
{
      std::cout << i->at(field) << std::endl;
      std::cout <<(*i)["columutobefetched"]  << std::endl;  //this will be slower     
}