现在有个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<
展开