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
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")