#include "D:\mmysql\mysql-5.1.55-win32_2\include\mysql.h"
#pragma comment(lib, "D:\\mmysql\\mysql-5.1.55-win32_2\\lib\\opt\\libmysql.lib")
int main(){
MYSQL *m_pMySQL;
MYSQL_RES *pResRet;
my_ulonglong RecordCount;
MYSQL_ROW pRow;
m_pMySQL = mysql_init(NULL);
if (m_pMySQL == NULL){
mysql_close(m_pMySQL);
}
if (mysql_real_connect(m_pMySQL, "localhost", "root", "your_password", "your_db",3306, NULL, 0))
{
if (
mysql_query(m_pMySQL, "Select * From user") == ERROR_SUCCESS)
{
if (pResRet = mysql_store_result(m_pMySQL))
{
RecordCount = mysql_num_rows(pResRet);
while (pRow = mysql_fetch_row(pResRet))
{
::MessageBoxA(NULL, pRow[2], "", NULL);
}
cout << "ok" << endl;
mysql_free_result(pResRet);
while (1);
}
}
}
cout << "err" << endl;
mysql_close(m_pMySQL);
while (1);
}