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
PDO Blob column adding , updating & displaying records
This article is written by plus2net.com team.