Hi, Richard,
Thank you for the reply.

On Sun, Jun 9, 2019 at 7:24 PM Richard Hipp <[email protected]> wrote:
>
> On 6/9/19, Igor Korot <[email protected]> wrote:
> >
> > Now I open this database in sqlite3 CLI binary and would like to insert some
> > png
> > file inside this BLOB field.
>
>
> INSERT INTO tab1(blob1) VALUES(readfile('some.png'));

I presume the file extension can be anything?
Looking at the documentation:

https://sqlite.org/cli.html

this looks to be the case.

Thank you.


>
> --
> D. Richard Hipp
> [email protected]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to