MySQL Crash Course

2017-07-07 02:10:07

Binary datatypes are used to store all sorts of data (even binary information), such as graphic images, multimedia, and word processor documents (see Table D.4).

Table D.4. Binary Datatypes
Datatype	Description
`BLOB`	Blob with a maximum length of 64K.
`MEDIUMBLOB`	Blob with a maximum length of 16MB.
`LONGBLOB`	Blob with a maximum length of 4GB.
`TINYBLOB`	Blob with a maximum length of 255 bytes.

Note

Datatypes in Use If you would like to see a real-world example of how different databases are used, see the sample table creation scripts (described in Appendix B, "The Example Tables").

Table D.4. Binary Datatypes

Категории