Hello,
Thanks for the reply, I will check out the mentioned links. I hope I
will get my answers there.
Regards,
Abubakr
----- Original Message -----
From: "Michael Kruckenberg" <[EMAIL PROTECTED]>
To: "Abubakr" <[EMAIL PROTECTED]>
Cc: "MySql Mail List" <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 10:07 PM
Subject: Re: copying longblob value to another table...
> 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
>
> Mike
> --
> http://mike.kruckenberg.com | [EMAIL PROTECTED]
>
--------------------------------------------------------------------------
NOTICE: This email and any files transmitted with it may contain privileged and
confidential information
and intended solely for the use of the individual or entity to whom they are
addressed. Please notify the
sender immediately by email if you have received this email by mistake, delete it
from your system and
you should not use, disseminate, distribute or copy this email.
Caution: Computer viruses can be transmitted via email. The recipient should check
this email and any
attachments for the presence of viruses
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
