c/vc/c++ 将mysql二进制字段（longblob类型）读出来保存成文件

最后的写文件操作，用的是cfile，记得选择要支持mfc

#include "StdAfx.h"
#include   <afxwin.h>
#include <stdio.h>

#include "winsock2.h"
#pragma comment(lib,"ws2_32")

#include <mysql.h>

#include <assert.h>

#include <string.h>

#include <stdlib.h>
#include "mysql.h"
#include "stdio.h"
#include "io.h"
#include "sys/stat.h"
#include <FCNTL.H>
#include<stdlib.h>
#pragma comment(lib,"libmySQL.lib")
#pragma comment(lib,"ws2_32")

 

void test_write(MYSQL& client)

{

    MYSQL_STMT* stmt = mysql_stmt_init(&client);

    assert(NULL!=stmt);

    const char* sql = "select file from tablename2";

    int sql_len = strlen(sql);

    int ret = mysql_stmt_prepare(stmt, sql, sq