...and so I'm tempted for the third time to bring up my issue which has to
date resulted in no response: BLOB columns causing various, seemingly random
"out of memory" errors on FreeBSD. Is this problem too low-level for the
list? I see plenty of responses to questions about simple queries, even
Thanks to everyone who responded to my query. Your responses have given
me a bit to think about.
Dang Nguyen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Tuesday 05 March 2002 10:05, Thomas Spahni wrote:
There are some good reasons for wanting to store data directly in the
database, sometimes.
For instance I built an application recently that used blobs. The reason is
simplicity and security. In a web application it is nice to just dump the
On Mon, 4 Mar 2002, Dang Nguyen wrote:
> I'd like to know how to load files, such as MS-Word documents or PDF
> documents, in a mySQL database. I've setup a blob type in a table, but
> where do I go from there?
>
> The purpose of this is to store files uploaded from a web page and processed
> w
ent: Tuesday, March 05, 2002 6:13 AM
To: 'Mysql List (E-mail)'
Subject: RE: storing files in mySQL
Why not rather have pointers to the files on a directory and store this
in a db field ? Saves you a lot of DB space ?
Ant
-Original Message-
From: Dang Nguyen [mailto:[EMAIL PROTECTED
Why not rather have pointers to the files on a directory and store this
in a db field ? Saves you a lot of DB space ?
Ant
-Original Message-
From: Dang Nguyen [mailto:[EMAIL PROTECTED]]
Sent: 04 March 2002 09:05
To: Mysql List (E-mail)
Subject: storing files in mySQL
Hi everyone,
I'd
Hi,
You should use the LOAD_FILE fonction to load your documents in the BLOB
field.
Ex: UPDATE table_name SET blob_column=LOAD_FILE("/some/where/picture");
You could find better explaination of that fonction in the manual at:
http://www.mysql.com/doc/S/t/String_functions.html
Regards,
Sébastie
