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') |
+---+
|
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
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
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 pictures as part of a record?
Should I
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
]
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]
-
Before posting, please check
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
+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 lets
-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