VS2015下C语言连接mysql数据库问题

1. 项目=》右键=》属性=》VC++ 目录 

添加mysql的include 和 lib路径

运行程序

// cgi_select.cpp : 定义控制台应用程序的入口点。//#include "stdafx.h"#include <Windows.h>#include <mysql.h>#pragma comment(lib,"libmysql.lib")MYSQL mysql;MYSQL_RES* result;MYSQL_ROW row;void main(){MYSQL mysql, *sock;mysql_init(&mysql);if (!(sock = mysql_real_connect(&mysql, "localhost", "root", "root", "webserver", 3306, NULL, 0))){printf("Cannot connect to database:%s\n", mysql_error(sock));return;}char sqlbuf[200] = "SELECT * FROM data";if (mysql_query(sock, sqlbuf)){printf("Query Failed:%s", mysql_error(sock));return;}MYSQL_RES *result;unsigned uLine = 0, uField = 0;MYSQL_ROW row;//MYSQL_FIELD **pField;pField = NULL;  MYSQL_FIELD *pField(NULL);unsigned long *lengths;if (!(result = mysql_store_result(sock))){printf("Failed to store result:%s", mysql_error(sock));return;}//获得行数  uLine = (unsigned)mysql_num_rows(result);//获得字段数  uField = (unsigned)mysql_num_fields(result);//获得字段的相关信息  //for(int j = 0; j < (int)uField; ++j)  //{  //  pField[j] =mysql_fetch_field_direct(result, j);  //}  pField = mysql_fetch_fields(result);//填充结果集  for (int i = 0; i<(int)uLine; i++){//获得一行数据  row = mysql_fetch_row(result);lengths = mysql_fetch_lengths(result);for (int j = 0; j<(int)uField; j++){//blob  MYSQL_FIELD *pTemp = pField + j;if (pTemp->type == MYSQL_TYPE_BLOB){//列名称  printf("%s:%d--%d ", pTemp->name, lengths[j], pTemp->max_length);for (unsigned long nindex = 0; nindex < lengths[j]; ++nindex){printf("%02X", row[j][nindex]);}}else{//列名称  printf("%s:%d--%d %s", pTemp->name, lengths[j], pTemp->max_length, row[j]);}printf("\t");}printf("\n");}//if(pField) delete []pField;  //释放结果集  mysql_free_result(result);// 关闭数据库  mysql_close(sock);}

出现错误

vs上方选择项目=》点击属性=》出现窗口=》右上角配置文件=》选择x64

然后重新配置一下"包含目录"和"库目录"

项目=》右键=》属性=》VC++ 目录 

添加mysql的include 和 lib路径

生成代码，编译通过

运行时出现找不到.lib库

将mysql server 的libmysql.lib和libmysql.dll拷贝到项目文件夹的DEBUG目录下

运行，成功