BLOB data types in MySQL

BLOB: binary large object
BLOB data types are used to store binary data types like images and other multimedia files. These are used for storing unstructured data.
Blob data type can't have default value.

Types of Blob

These types of Blob columns only differs in the maximum length of data it can hold.

TINYBOB (255 bytes)
BLOB (64 KB)
MEDIUMBLOB (16 MB)
LONGBLOB (4 GB)

While using Query, blob columns should not be called if they are not really needed.
SELECT * FROM table_name
Above query calls all columns including blob.
Data Types PDO Blob column adding , updating & displaying records

Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com






    Post your comments , suggestion , error , requirements etc here





    SQL Video Tutorials










    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2022 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer