原码:
void Save_stu() { //读取数据库
mysql_init(&mysql);
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "gbk");
if (mysql_real_connect(&mysql, "127.0.0.1", "root", "123123", "ce01", 3306, NULL, 0) == NULL)
//返回0 查询成功,返回1查询失败
if (mysql_query(&mysql, "SELECT * FROM `Student`")) { //执行SQL语句
printf("执行语句失败 %s\n", SDL_GetError());
}
if (0 != mysql_query(&mysql, "select * from Student")) {
printf("%s\n", mysql_error(&mysql));
}
MYSQL_RES* result = NULL;
int num_rows = 0, num_fields = 0;
result = mysql_store_result(&mysql);//获取查询结果
num_rows = mysql_num_rows(result);//行
num_fields = mysql_num_fields(result);//列
row = mysql_fetch_row(result); // MYSQL_ROW row; char** 二维数组,存放一条条记录
while (row = mysql_fetch_row(result)) {//返回结果集中行的记录
printf(" %s ", row[0]);
printf(" %s ", row[1]);
printf(" %s ", row[2]);
printf(" %s ", row[3]);
printf("\n");
}
}
如图: