insert a BLOB via a sql script ?
- by David Michel
Hi,
I have an H2 database (http://www.h2database.com) and I'd like to insert a file into a BLOB field via a plain simple sql script (to populate a test database for instance). I know how to do that via the code but I cannot find how to do the sql script itself.
I tried to pass the path , i.e.
INSERT INTO mytable (id,name,file)…