How to set longblob to null

Databases
1

Hi,
I have images in my table as longblob type. I tried using the UPDATE statement to set the column to null, but for some reason it didnt update. It did show the query was successful.

I tried something along this line:
update icons
set icon = null
WHERE icon_location is not null

Thanks,

2

Is NULL allowed for the field? i.e. you didn’t define it with NOT NULL?
Can you show a SHOW CREATE TABLE for the concerned table?

3

I have it set as default value of null. I thought I would be able to replace binary data with null value or some default value.

CREATE TABLE icons (
id int(11) NOT NULL auto_increment,
icon longblob,
icon_location varchar(200) default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=67436 DEFAULT CHARSET=latin1

4

Any suggestions?