Use the following query to get the Size of Image column for each row. "Image" is a column defined as MEDIUMBLOB in a MySQL database
Select ID, name, OCTET_LENGTH(Image) from catalog
Was very useful in making sure my PHP script to upload Images to the database was working okay or not!
Showing posts with label blob. Show all posts
Showing posts with label blob. Show all posts
Friday, May 29, 2009
Subscribe to:
Posts (Atom)