row 接收的结果集 为啥第一条输出不了?

   原码:


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");
	}  
}

如图:

row = mysql_fetch_row(result); // MYSQL_ROW row; char** 二维数组,存放一条条记录

把这一行代码删掉就好了

代码中调用了两次mysql_fetch_row方法,这导致while循环中调用的mysql_fetch_row实际上取到的是第二条数据

第一行被row = mysql_fetch_row(result);取到了

mysql_fetch_row()函数每一次调用都会自动指向下一条数据