RE: Saving Images - Adam Clauss - com.mysql.lists.win32

17 messages in com.mysql.lists.win32RE: Saving Images

From	Sent On	Attachments
Kathy Mazur	13 Aug 2003 09:09
David Felton	13 Aug 2003 09:19
Jason Corcoran	13 Aug 2003 09:31
Rajesh Kumar	17 Aug 2003 18:42
Harpreet	17 Aug 2003 20:48
Erich Dollansky	17 Aug 2003 21:16
Harpreet	17 Aug 2003 21:47
Erich Dollansky	17 Aug 2003 22:03
Virginia R. Hetrick	17 Aug 2003 22:51
Stuart M. Robinson	18 Aug 2003 13:38
Tim Endres	18 Aug 2003 21:30
Yogesh Kadalgikar	19 Aug 2003 01:44
Erich Dollansky	19 Aug 2003 05:59
Trevor Watson - Gateway Software Productions	19 Aug 2003 07:08
Bhupinder	19 Aug 2003 08:31
Armin Schöffmann	19 Aug 2003 09:06
Adam Clauss	19 Aug 2003 12:38

Subject:	RE: Saving Images
From:	Adam Clauss (caba...@houston.rr.com)
Date:	08/19/2003 12:38:46 PM
List:	com.mysql.lists.win32

Yes - it IS possible. I used the following when creating part of an application in C++ to store files (of unknown type):

UPDATE mail SET data = CONCAT(data, LOAD_FILE("path_of_file_to_store"));

I trimmed off part of it that wasn're relevant to this (had a WHERE clause). Even though this is actually an UPDATE statement to append info to an existing entry, you should be able to get the gist of it enough to use it however you need.

Hope that helps,

-----Original Message----- From: Bhupinder [mailto:sin...@bellsouth.net] Sent: Tuesday, August 19, 2003 10:32 AM To: Trevor Watson - Gateway Software Productions Cc: win...@lists.mysql.com Subject: RE: Saving Images

Thanks for all the replies and responses.

I guess what I wanted to find out first is that can I use SQL statements to upload the file to the MySQL database server. After going thru all the articles and other help I learned that it is not possible. I am finding this hard to believe. But I guess this is true. Let me now if it is not.

Regards

-----Original Message----- From: Trevor Watson - Gateway Software Productions [mailto:tre...@gatewaysoftware.ca] Sent: Tuesday, August 19, 2003 10:09 AM To: win...@lists.mysql.com; harp...@crispincorp.com Subject: Re: Saving Images

There is an article on the VBMySQL.com web site that will help you do what you want. You can see the article at: http://www.vbmysql.com/articles/blobaccessvb.html

Trevor Watson

Hi,

Yogesh Kadalgikar wrote:

if the programming language is say VB. What is the procedure then. I am facing a problem on that

This I do not know, I use only C.

Regards, Yogesh

----- Original Message ----- From: "Erich Dollansky" <ocea...@pacific.net.sg> To: "Harpreet" <harp...@crispincorp.com> Cc: <win...@lists.mysql.com> Sent: Monday, August 18, 2003 10:33 AM Subject: Re: Saving Images

Hi,

Harpreet wrote:

What is the sql syntex to insert an image into the

table. I would like

try it out just for experience sake.

It is the normal SQL syntax. But you have to 'escape' the BLOB before inserting it into the SQL statement. SQL statements always have to be strings.

How this is done depends on your programming language.

Thanks for your prompt reply.

Is there a document or site online that talks about it.

I do not know.

Erich

Thanks,

Regards, Harpreet

Hi,

yes, you can do it but MySQL becomes pretty slow.

It is faster to save the file to the filesystem and write only the location of the file to the database.

Erich

Harpreet wrote:

In mysql can we create a field in a table that can

save images as the

data?

I know there is a field type BLOB. Can it save images in it.

Please let me know.

Thanks,

http://lists.mysql.com/win32?unsub=yoge...@rakya.com

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?> unsub=sin...@bellsouth.net

MySQL Windows Mailing List

For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?> unsub=caba...@houston.rr.com