Re: [sqlite] how to show image

On Thu, 7 Jun 2012 02:10:44 +, YAN HONG YE wrote: > >sqlite3_exec(db,"create table image (filename varchar(128) unique,img >blob);",0,0,); >and put image to my sqlite db: >sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); > >I export the html

[sqlite] how to show image

sqlite3_exec(db,"create table image (filename varchar(128) unique,img blob);",0,0,); and put image to my sqlite db: sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); I export the html use this command: sqlite3 -html film.db "select * from image;">my.html but I