记录编译 mysql C and C++ connector 和简单访问数据库.
环境: vs2012, mysql 5.6.13, 基于x64
0. 软件包
mysql http://dev.mysql.com/downloads/mysql/
c connector http://dev.mysql.com/downloads/connector/c/
c++ connector依赖C connector, mysql的binary里面有编译好的C connector lib, 如果你用的编译器和mysql 一样, 那么不用重新编译
c++ connector http://dev.mysql.com/downloads/connector/cpp/
boost http://sourceforge.net/projects/boost/files/boost/1.54.0/
c++ Connector 依赖boost. 本来还尝试过vs2013, 但是boost1.54在vs2013 preview下编译有问题, 我没有试低版本的boost.
cmake http://www.cmake.org/cmake/resources/software.html
mysql的project是基于cmake. cmake可以生成vc project, 使用起来挺方便
1. 环境bat vs2012x64env.bat
call "C:\Program Files (x86)\Microsoft Visual Studio 11.0\VC\vcvarsall.bat" amd64
set PATH=%PATH%;D:\mybin\cmake-2.8.11.1-win32-x86\bin
set MYSQL_DIR=D:\mybin\mysql-5.6.13-winx64
set BOOST_ROOT=D:\mybin\bo