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 & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

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