mysql c api blob_利用mysql C api批量导出Blob文件到指定文件，在线等，急！

现在有个test表，具体结构如下：createtabletest(idintnotnullprimarykey,namevarchar(50),datablob);现在想要把所有data数据下载到某个制定文件下，我写的函数如下：voidtest1(strin...

现在有个test表，具体结构如下：create table test(id int not null primary key,name varchar(50),data blob);现在想要把所有data数据下载到某个制定文件下，我写的函数如下：void test1(string tablename,int id,string storepath){ const char *tablename1; const char *picture1; const char *storepath1; char szSql[1024]; MYSQL *mysql = mysql_init(NULL); if (!mysql_real_connect(mysql,"localhost","root","123456","mysql",3306, NULL, 0)) { int ret = mysql_errno(mysql); mysql_close(mysql); } memset(szSql,0,sizeof(szSql)); tablename1=tablename.c_str(); storepath1=storepath.c_str(); cout<

展开