为何出现这个error:Truncated incorrect DOUBLE value

counterking

当我执行以下的sql statement 出现这个error msg :　Truncated incorrect DOUBLE value

UPDATE inventory_item SET IID = 'projector001' AND status = 'Active' WHERE IID = 'projector007'

注: datatype to IID = VARCHAR

i using mysql 5.0

[ 本帖最后由 counterking 于 15-11-2007 12:35 PM 编辑 ]

路過人甲

试一试
UPDATE inventory_item SET IID = 'projector001', status = 'Active' WHERE IID = 'projector007'