Table definition includes a BLOB column named Photo : Blob « Data Type « SQL / MySQL






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

Table definition includes a BLOB column named Photo

     
mysql>
mysql> CREATE TABLE Inventory
    -> (
    ->     ProductID SMALLINT UNSIGNED,
    ->     Name VARCHAR(40),
    ->     Photo BLOB,
    ->     Quantity INT UNSIGNED
    -> );
Query OK, 0 rows affected (0.01 sec)

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








Related examples in the same category

1.BLOB Binary data with variable length, maximum 2^16-1 bytes
2.TEXT and BLOB Data Type Sizes and Upper Limits (in Bytes)