Hello avegaaraya,
Thursday, May 31, 2001, 6:12:09 PM, you wrote:
ann> I'm using mysql in win9x, and I want to know how to load a JPG image into a table
ann> __________________________________________________________________
ann> Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/
ann> ---------------------------------------------------------------------
ann> Before posting, please check:
ann> http://www.mysql.com/manual.php (the manual)
ann> http://lists.mysql.com/ (the list archive)
ann> To request this thread, e-mail <[EMAIL PROTECTED]>
ann> To unsubscribe, e-mail <[EMAIL PROTECTED]>
ann> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Use LOAD_FILE function in INSERT or UPDATE, for example:
INSERT table_name SET img_column_name=LOAD_FILE('img_file_name.jpg');
table_name should be one of the "big" types. MEDIUMBLOB or LONGBLOB
are nice. File img_file_name.jpg must be on the server (where mysqld
is running). In your situation server and client are running on the
same computer, so it's gonna be alright.
--
Best regards,
Olexandr mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
