2020-10-04

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