How can I upload a picture as blob
Please help me.
I have to upload a picture from a local directory of my computer directly to the mysql tables using insert.
I have inserted a picture using this statement
insert into tablename values(load_file('filename')).
but in order for this statement to work, i have to put the picture in this directory c:/mysql/data/
Is it possible to put the image in the database using the server?
for example, the file is located on the localhost, can I possibly insert the file as blob in the table?
please provide a code, it will really help me a lot in making my special problem for my undergraduate degree. thanks.
Subject
Written By
Posted
How can I upload a picture as blob
January 25, 2005 09:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.