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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment