splitzer — 2010-12-21T13:31:51-05:00 — #1
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
scallioxtx — 2010-12-21T13:43:36-05:00 — #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?
splitzer — 2010-12-21T13:50:20-05:00 — #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.
id int(11) NOT NULL auto_increment,
icon_location varchar(200) default NULL,
PRIMARY KEY (
) ENGINE=InnoDB AUTO_INCREMENT=67436 DEFAULT CHARSET=latin1
splitzer — 2010-12-22T22:57:27-05:00 — #4