Thread: retrieving data from a mysql table thorugh c++

Hi,
I'm trying to figure out how I can pull out an element of a mysql table and set it into a variable in c++.

For example if the table called Stock were the following:
+-----------+-------+-------+
: Date : Open : Close :
+-----------+-------+-------+
: 2009-09-21 : 34.27 : 34.19 :
: 2009-09-22 : 34.32 : 34.08 :
+-----------+-------+-------+

and I wanted to set a variable named price equal to the element in (2,2) or 34.32.

Thanks and advance for the help

the mysql client C library will do what you're asking about, and there's also an official C++ wrapper for it. go to the mysql C++ connector page for more info.