函数在mysql中文参考手册的API部分有讲：http://www.cbi.pku.edu.cn/chinese/documents/csdoc/mysql/manual_Clients.html#C
【mysql5.6】连接vs2010
标签：
【mysql5.6】连接vs2010
"winsock.h"
#include "mysql.h"
using namespace std;
int main()
{
MYSQL * mysql;
mysql = mysql_init(NULL);
char * sql = "select * from emp";
MYSQL_RES * result;
MYSQL_ROW row;
int r, num;
if(mysql_real_connect(mysql, "localhost","root",NULL,"test1",3306,NULL,0))
{
mysql_set_character_set(mysql,"gbk");
if(!mysql_query(mysql, sql))
{
result = mysql_store_result(mysql);
if(result == NULL)
return 0;
num = mysql_num_fields(result);
unsigned long * lengths = mysql_fetch_lengths(result);
while(row = mysql_fetch_row(result))
{
for(r = 0; r < num; ++r)
{
cout<<row[r]<<‘ ‘;
}
cout<<endl;
}
mysql_free_result(result);
}
mysql_close(mysql);
}
return 0;
}