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
Processed:
0.009, SQL:
8
