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)

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 to our YouTube Channel here


* indicates required
Subscribe to plus2net

    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-2024 All rights reserved worldwide Privacy Policy Disclaimer