Jump to content


This topic is now archived and is closed to further replies.


Update/delete blob - how to

Recommended Posts

Hi, Just wondering if anyone can give me some pointer on how to delete/update BLOB properly. My app stores articles/documents/images in mysql. Inserting files works great, but if I delete a row which has, say a 2mb pdf file, the mysql table size does not decrease (table.MYD). What would be the proper way to delete/update blob column? Is there specific functions that I use? I searched extensively on search engine but no luck finding anything.

Thanks in advance for you help.


Share this post

Link to post
Share on other sites
Another question: I have a lot of php scripts, getting kinda troublesome to manage. So I am storing those scripts in mysql and retrieving by id, so the link would look like http://localhost/controller.php?id=pageid ..............what should be header() for content-type for these scripts to execute? my browser is interpreting as application/octet-stream and prompting to save the file rather than executing as a regular php page.


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.