工具vc2022
导入文件目录及依赖后:
#include
#include <mysql.h>
using namespace std;
int main() {
MYSQL mysql;
MYSQL_RES* res;
MYSQL_ROW row;
mysql_init(&mysql);
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "gbk");//UTF_8没用报错
if (mysql_real_connect(&mysql,"127.0.0.1","root","214360","library",3306,NULL,0)==NULL)
{
cout << mysql_error(&mysql) << endl;
cout << "链接失败!!!";
}
int ret = mysql_query(&mysql, "select *from books;");
cout << ret << endl;
res = mysql_store_result(&mysql);
while (row=mysql_fetch_row(res))
{
cout << row[0]<<endl;
cout << row[1]<<endl;
cout << row[2]<<endl;
cout << row[3]<<endl;
cout << row[4]<<endl;
}
//关闭资源
mysql_free_result(res);
mysql_close(&mysql);
}