hi,
try like this query.
create table file(name varchar, data binary);
insert into file values ('filename', file_read('/path/to/file'));
litailang
2013/5/23 Andreas Fischer <[email protected]>:
> Hey there,
>
> What is the nicest/fastest way to import a binary file content into a data
> base table?
> I have some binary files and i want to merge them into one data base table.
> The key is the file name and a field of type BINARY named 'data' should
> contain the exact copy of the file content.
>
> Thanks in advance.
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.