mysql probably does not have search permission on /home/alex.
copy the file to /tmp and see what happens.
Alex Safonov wrote:
>Greetings,
>
>just saw a message with an example of inserting a BLOB
>value using load_file(). Can't get load_file() to
>work:
>
>mysql> select load_file('/home/alex/pos
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql> select load_file('/home/alex/post.html') from
test;
+---+
| load_file('/home/alex/post.html') |
+---+
|
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roland Perez wrote:
| Can I use MySQL to store pictures as part of a record?
| Should I just try to store the name of the picture?
Yep but it depends on the size of the pictures. We produce certificates
here and we hold images of engineer signatures
> +1
>
> For medical imaging, at least in radiology (PACS), you usually see the
> terabytes of images being stored on a NAS somewhere, and the database
> itself is actually pretty small just pointing to filenames of where the
> pictures are located. This keeps the database small and fast, and le
> Can I use MySQL to store pictures as part of a record?
You CAN.
> Should I just try to store the name of the picture?
Yes. If you have FTP Access or similiar, I would prefere this!
Some remarks from the manual :
-- Insert a File located locally on MySQL-Serverinto a blob-column
INSERT INTO m
2002 9:35 AM
> To: [EMAIL PROTECTED]
> Subject: Store pictures in DB
>
>
> Can I use MySQL to store pictures as part of a record?
> Should I just try to store the name of the picture?
>
> Thanks for any help
> Roland Perez
> [EMAIL PROTECTED]
>
>
You can store pictures in a BLOB field, but it is generally recommended that
you simply store the filename of the picture.
-Original Message-
From: Roland Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 9:35 AM
To: [EMAIL PROTECTED]
Subject: Store pictures in DB
Can
http://www.mysql.com/doc/en/BLOB.html
> -Original Message-
> From: Roland Perez [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 24, 2002 3:35 PM
> To: Receipt Notification Requested
> Subject: Store pictures in DB
>
>
> Can I use MySQL to store pict
Can I use MySQL to store pictures as part of a record?
Should I just try to store the name of the picture?
Thanks for any help
Roland Perez
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
