c mysql 读取blob_【推荐下载】c-c++ 获取mysql数据库以blob类型储存的图片

c/c++

获取

mysql

数据库以

blob

类型储存的图片

2018/04/18 39

if (NULL == mysql_real_connect( conn, host, username, password,

dbname, 0, NULL, 0)) cerr

“connect

to database

error”

endl; exit(-1); char sql[] =

“select

octet_length(picture),

picture

from

tablename”;

if

(0

!=

mysql_real_query(

conn,

sql,

strlen(sql)))

cerr

“query

error.”

endl;

exit(-1);

MYSQL_RES

*

result

=

NULL;

result

=

mysql_store_result( conn); if (NULL == result) cerr

“store

result

error.”

endl; exit(-1); if

(0 = mysql_affected_rows( conn)) cerr

“no

data be