C.F. Scheidecker Antunes wrote:
I want to insert the blob file from table1 where id = 1 to table2.
To select the blob I would issue: select file from table1 where id = 1
To insert I would do: insert into table2 (blob) values(?)
INSERT INTO table2 (blob) SELECT file FROM table1 WHERE id=1
--
J
Hello everyone:
I have two tables that store a blob.
They both have Id fields.
What I would like to do is, given an id, copy the blob stored on table
one to table two.
I could do that in my java program by selecting and retrieving the blob
from table 1 and then issuing
a insert/replace statemen
