我在DB2中使用的sql语句为: update t_cm_user set user_photo = null where user_name = 'qq' 我的目的是将一个user_photo(blob的字段)置空,在DB2中测试,DB2会一直执行用不停下来,也不报错。 我的问题是怎样将以一个blob字段置空?
update user set user_photo ='' where user_name ='qq'
To heyday(水中天) : 试过了,这样就报错:DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0408N A value is not compatible with the data type of its assignment target. Target name is "USER_PHOTO". SQLSTATE=42821
试试看就知道对错…
update t_cm_user set user_photo = null where user_name = 'qq'
我的目的是将一个user_photo(blob的字段)置空,在DB2中测试,DB2会一直执行用不停下来,也不报错。
我的问题是怎样将以一个blob字段置空?
试过了,这样就报错:DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0408N A value is not compatible with the data type of its assignment target. Target name is "USER_PHOTO". SQLSTATE=42821