[TOC] ### 下載安裝包 ***** 1. 官網下載mysql (以5.6為例子)[下載地址](https://dev.mysql.com/downloads/mysql/) 下載的是win32版本的（版本要跟項目版本一致x32 x64） ### 配置 ***** 配置屬性 -> C/C++ -> 常規 -> 附加包含目錄 -> include文件夾 (vc++目錄-》包含目錄 設置成mysql5.6/include) 配置屬性 -> 連接器 -> 常規 -> 附加庫目錄 -> lib文件夾 (或者 #pragma comment(lib,"libmysql.lib")) ### 代碼示例 ***** ```c++ #include "stdafx.h" #include <iostream> #include <stdio.h> #include <winsock.h> #include <mysql.h> using namespace std; #pragma comment(lib,"wsock32.lib") #pragma comment(lib,"libmysql.lib") int main() { const char user[] = "root"; const char pswd[] = "root"; const char host[] = "11.11.111.111"; const char table[] = "DB_NAME"; unsigned int port = 3306; MYSQL myCont; MYSQL_RES *result; MYSQL_ROW sql_row; int res; mysql_init(&myCont); if (mysql_real_connect(&myCont, host, user, pswd, table, port, NULL, 0)) //if (mysql_real_connect(&myCont, host, user, pswd,0,0,NULL,0)) { mysql_query(&myCont, "SET NAMES UTF8"); //設置編碼格式 // mysql_select_db(&myCont, table); res = mysql_query(&myCont, "select * from level_1");//查詢 if (!res) { result = mysql_store_result(&myCont); cout << "結果集數量:" << mysql_num_rows(result) +1<< endl; if (result) { while (sql_row = mysql_fetch_row(result))//獲取具體的數據 { cout << "ID:" << sql_row[1] << endl; cout << "Name:" << sql_row[2] << endl; } if(!mysql_query(&myCont, "insert into level_1(Name,Count) values('DongGuoZheng',2)")){ cout << "插入成功" << endl; } else { cout << "shibai" << endl; cout << mysql_error(&myCont) << endl; } } } else { cout << "query sql failed!" << endl; } } else { cout << "connect failed!" << endl; } if (result != NULL) mysql_free_result(result); mysql_close(&myCont); system("pause"); return 0; } ```