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 -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]