This example illustrates how to create the BLOB type field in table.
In this example we create a 'pictures' table with id integer type and image field blob type.
Query
|
CREATE TABLE `pictures` ( `id` int(11) NOT NULL auto_increment, `image` blob, PRIMARY KEY(`id`) ); |
Output
|
+-------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | | auto_increment | | image | blob | YES | | | | +-------+---------+------+-----+---------+----------------+
|