Nick,
Tuesday, April 09, 2002, 5:21:00 PM, you wrote:
NS> Is there a way to store files in MySQL? Looking to store somthing like a
NS> zip file in the databaseand be able to retrieve/download it from something like
ASP.
Yes, you can store files in the BLOB fields. You can find some info
about B
...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
Blob field may do the trick but wouldn't it easier to store it on the drive?
- Original Message -
From: "I.SivaramaKrishnan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 17:05
Subject: storing files in database
> Hi all,
>
> Basically I have a requirement
Are U going to search thru the XML data in the future?
If so U have to be carefull ..
If not, depending on size u have these options
1. text(64K) or blob(64K)
2. mediumtext(16MB) or mediumblob(16MB)
Cheers!
Thiru
If U may search thru the XML data at some point,
On Fri, 16 Feb 2001 14:35:5
10 matches
Mail list logo
