hi,
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. 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. This is the structure of my tables
CREATE TABLE testing (
file_no tinyint(4) NOT NULL auto_increment,
id tinyint(4) default NULL,
filename varchar(20) default NULL,
doc longblob,
PRIMARY KEY (file_no)
) TYPE=MyISAM;
and the 2nd one is as follows
CREATE TABLE upload (
file_no tinyint(4) NOT NULL auto_increment,
id tinyint(4) default NULL,
filename varchar(20) default NULL,
doc longblob,
PRIMARY KEY (file_no)
) TYPE=MyISAM;
now how can i copy row from one table to another table
Thanks in advance.
Regards,
Abubakr
--------------------------------------------------------------------------
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
