----- Original Message -----
From: "Fabiana Garfunkel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 20, 2002 7:18 AM
Subject: question: saving a file into a field of a table
> Hello, my name is Fabiana Garfunkel, and I´m new in MySQL developing.
>
> I have a punctual question: I need to save a zipped file into a field of a
> table. The question is:
> 1- is it possible to save a file into a field of a a table ?
Yes.
> 2- if the answer is YES, which is the proper type of field for this ?
Blob, MediumBlob,L..
> 3- how can I save a file into a field ?
LOAD DATA INFILE 'C:/a.zip' into table <your table> ;
> 4- how can I read or retrieve the file saved in a field of a table ?
>
SELECT <fieldName> FROM <your table> INTO OUTFILE 'a.zip' ;
If you don't specify any path, default will be
MYSQLHOME/DATA/YOURDATABASE/a.zip
> Thanks a lot and best regards !!!
GoodLuck
> Fabiana
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
