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

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com

Queries INSERT UPDATE

Aggregate Queries AVG ( Average ) SUM MIN MAX

SQL Video Tutorials