UPDATE t_dsc_online_item_info set state=0 where item_no in ( SELECT item_no FROM t_dsc_online_item_info WHERE CAST(goods_number AS decimal) < 0 ) 数据库中 goods_number 居然是varchar类型,这样CAST(goods_number AS decimal) < 0 ) 进行类型转化.原数据为 0.0000