copy image blob data in MySQL table

[hornhaver]

Hi there
I have image upload and image viewing/retrieving working OK with my MySQL using BLOB, but I need to be able to copy the blob data from one tabel to another. Using a simple select and insert is not working. Any clues?
Cheers

[bastien]

yeah, don't store images in the db...dbs store images by placing the image a virtual folder and holding a pointer in the column...simpler to store the path/image name as text string and use that when referencing the image....

simpler to move, better performance, less db size etc