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 statement to table 2. But it is not elegant. Hence I
wonder if anyone would have a better
suggestion of something better.
table1:
id - integer
file - blob
table2:
id - integer
file - blob
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(?)
I am using MySQL 4.1.12.
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]