BLOB Binary data with variable length, maximum 2^16-1 bytes : Blob « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Blob

BLOB Binary data with variable length, maximum 2^16-1 bytes

  
mysql>
mysql> CREATE TABLE employee(
    ->     id INT,
    ->     eName VARCHAR(10),
    ->     photo BLOB
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table employee;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>








Related examples in the same category

1.TEXT and BLOB Data Type Sizes and Upper Limits (in Bytes)
2.Table definition includes a BLOB column named Photo