Menu
Is it possible to automatically assigned the value of a BLOB column in MySQL without uploading a file everytime a new line is included?
362
BLOB and TEXT columns cannot have DEFAULT values. Thus, if the column is NULLABLE then NULL is the default; otherwise there is no default value. (Although, at the application level, a blob of length=0 might be a sensible "default".)
An object which may specify any of the following properties: type Optional. The MIME type of the data that will be stored into the blob. The default value is the empty string, ( "" ).
BLOB Editor is invoked from data grid of any table editor or the result tab of SQL Editor and Visual Query Builder by double clicking of the BLOB field to be edited or with the Edit BLOB link of the field's popup menu. The editor also can be called from BLOB Viewer with the Edit current BLOB button.
LONGBLOB: A binary large object column with a maximum length of 4294967295 (2^32 - 1) bytes, or 4GB in storage. Each LONGBLOB value is stored using a four-byte length prefix that indicates the number of bytes in the value.
The DEFAULT value clause in a data type specification indicates a default value for a column.
Nevertheless BLOB and TEXT columns cannot be assigned a default value.
From: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html
130
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
