How would someone store a image in MySql ? Would I have to store it as a Blob ?
That's if its even possible can't see why it wouldn't be though.
Asked
Active
Viewed 1,883 times
-2
-
1It is possible but **why** do you need that? – zerkms Oct 09 '13 at 09:11
-
read this http://stackoverflow.com/questions/527801/php-to-store-images-in-mysql-or-not?rq=1 – naveen goyal Oct 09 '13 at 09:12
-
possible duplicate of [Storing images in MySQL](http://stackoverflow.com/questions/3014578/storing-images-in-mysql) – John Parker Oct 09 '13 at 09:14
-
Please search for existing questions before you add a new one - this topic has been covered on numerous occasions. As recommendation, you should also read http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay as to why you most likely don't want to do this. – John Parker Oct 09 '13 at 09:14
-
1[storing-images-in-db-yea-or-nay](http://stackoverflow.com/questions/3748/) – juergen d Oct 09 '13 at 09:15
-
What have you done uptill now?? – The Hungry Dictator Jan 10 '14 at 12:16
3 Answers
1
You can use BLOB to store images in database. But I think recommended way is to store the image path in the database not the whole image
Thusitha Thilina Dayaratne
- 5,666
- 4
- 42
- 69
0
You can always store the file path for where the image is located, instead of actually storing the image itself.
SEB BINFIELD
- 410
- 3
- 12
-1
You can store images in database if you require security. But if you store image as blob it slow down your application. Retrieving images from folder is much faster. and another problem is If database is corrupted, no way to retrieve.
Vivek Pawar
- 339
- 3
- 5