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:
set icon = null
WHERE icon_location is not null
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?
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.
id int(11) NOT NULL auto_increment,
icon_location varchar(200) default NULL,
PRIMARY KEY (
) ENGINE=InnoDB AUTO_INCREMENT=67436 DEFAULT CHARSET=latin1