c++连接mysql测试

工具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);

}

结果