Shulou(Shulou.com)05/31 Report--

What is the role of the BLOB field type in MySQL? I believe many inexperienced people don't know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Fields of type BLOB are used to store binary data

In MySQL, BLOB is a family of types, including TinyBlob, Blob, MediumBlob, and LongBlob. The only difference between these types is in the maximum size of the storage file.

Four BLOB types of MySQL

Type size (in bytes)

TinyBlob maximum 255i

Maximum of 65K for Blob

MediumBlob up to 16m

LongBlob maximum 4G

After reading the above, have you mastered the function of the BLOB field type in MySQL? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.