MySQL Forums
Forum List  »  General

How can I upload a picture as blob
Posted by: Melvin Protacio
Date: January 25, 2005 09:07AM

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.

Options: ReplyQuote


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.