mysql++

sudo apt-get install mysql++-dev

sudo ./configure --prefix=/usr --enable-thread-check --with-mysql-lib=/usr/lib/x86_64-linux-gnu
vim Makefile, add LIBS = -l pthread

sudo make

sudo make install

g++ a.cpp -Wall -L/usr/lib/x86_64-linux-gnu -lmysqlclient -L/usr/lib -lmysqlpp -I/usr/include/mysql -I/usr/include/mysql++ -o a.out
找不到头文件mysql_version.h，告诉gcc去哪找头文件，-I/usr/include/mysql

注意依赖顺序，a.cpp要引用libmysqlpp.so，a.cpp在前

StoreQueryResult --> vector(string),row --> col1 col2 col3

result[1][4]，随机访问，代价大

Query::use() --> UseQueryResult，单向，数量未知，代价小，因为结果集不是整个存储在ram中

struct stock{}
vector<stock> vs
query << "select * from tbphone"
query.storein(vs)
for (vector<stock>::iterator it = vs.begin(); it != vs.end(); ++it)
cout << it->price

vector<mysqlpp::Row> vr
query.storein(vr)
for (vector<mysqlpp::Row>::iterator it = vr.begin(); it != vr.end(); ++it)
cout << it->at("price")