List:General Discussion« Previous MessageNext Message »
From:Jose de Leon Date:August 1 1999 2:56am
Subject:Re: Binary Data & MySQL
View as plain text  
I was about to ask the same question as Bryan.  However, I would have to
upgrade to use that function call.

How stable is the newest version of MySQL?

Is there an alternative method to get binary data into a table?   Other than
LOAD INFILE?

Thanks,
Jose



----- Original Message -----
From: Jani Tolonen <janikt@stripped>
To: Bryan Porter <bporter@stripped>
Cc: <mysql@stripped>
Sent: Saturday, July 31, 1999 4:41 PM
Subject: Binary Data & MySQL


Bryan Porter writes:
 > If I want to store binary data (images, soundfiles, etc) inside the MySQL
 > database, how do I get these files into the database? Is there a way to
do
 > this using the DBI/DBD interface with perl?
 >
 > Any help would be greatly appreciated!
 >
 >
 > Regards,
 > Bryan Porter
 > Programmer/Analyst
 >

Hello Bryan,

In the newest version of MySQL (3.23) you can use function
load_file(filename). Please see manual for more information.

Regards,

- Jani

--
+-------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen     |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       jani@stripped   |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki         |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland          |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                   |
|             /*/             \*\            Developers Team  |
+-------------------------------------------------------------+

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread8988@stripped

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.



Thread
Binary Data & MySQLBryan Porter30 Jul
  • Re: Binary Data & MySQLSasha Pachev30 Jul
  • Binary Data & MySQLJani Tolonen1 Aug
  • Re: Binary Data & MySQLJose de Leon1 Aug
    • Re: Binary Data & MySQLMartin Ramsch1 Aug
    • Re: Binary Data & MySQLJani Tolonen2 Aug