On Wed, 30 Mar 2011 12:51:11 -0400, "Santin, Gloria"
<sant...@westinghouse.com> wrote:
>Sorry, my question was not clear enough...
>I need to open a file and store the contents into the BLOB field. Some of the
>files are images and some are document templates.
>Can I do that using just SQL commands from a command line?
>
>Thanks,
>Gloria
Yes, here's a oneliner (tested on Solaris):
d=test.db3 ; echo "CREATE TABLE Files (name TEXT PRIMARY
KEY,contents BLOB);" | sqlite3 $d ; for f in yourfiles* ; do echo
"INSERT INTO Files (name,contents) VALUES ('$f',X'$(od -A n -t x1
$f|tr -d '\r\n\t ')');" | sqlite3 $d ; done
HTH
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
