Abubakr wrote:
> I am trying to copy a file stored in longblob column of a table to a longblod column of another table, can any one tell me what kind of insert statement should i use for that purpose.
You should be able to insert into your upload table with a select from your testing table. This doc explains the syntax:
http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
> 2ndly can any one tell me any built in function in mysql to download a file from longblob column to your local disk, i m aware of 'load_file' function to save a file from local disk to mysql DB but unable to find a function to download a file.
You can add 'into dumpfile' to the select to get blob data into a file:
select <column> into dumpfile '<filename>' from . . .
The SELECT doc gives more details:
http://dev.mysql.com/doc/mysql/en/SELECT.html
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
