MySQL获取字段信息并打印全字段数据mysql_fetch_file

mysql_fetch_field_direct(result,i);
//或者
mysql_fetch_field(result);

MYSQL_RES*result;

MYSQL_FILE*file;
/*
while(file=mysql_fetch_file(result))
{
    cout<<"Key:"<<file->name<<endl;//输出result的字段名

}
*/

int fnum=mysql_num_filed(result)//获取字段名的数量

MYSQL_ROW*row;
while(row=mysql_fetch_row(result))
{
    for(int i=0;i<fnum;i++)
    {
        cout<<mysql_fetch_field_direct(result,i)->name<<":";
        if(row[i])
            {
           cout<<row[i]<<endl;
           cout<<",";
            }
        else
            {
        cout<<"NULL";
        cout<<",";
            }
       cout<<"\n====================="<<endl;
    }
}
//清理数据
mysql_free_result(result);