/*延爆是指延期次数过多，导致数据混乱的情况，基本表现为突然出现大量商品价格为0*/

select*from item where num3>0
select*from item where class_no not in(select class_no from ba_cls_info)
update item set class_no=reverse(ltrim(rtrim(class_no)))where class_no not in(select class_no from ba_cls_info)
update item set sale_price=num3 where sale_price=0 and num3<>0
update item set num3='.000000'where num3<>0

/*依次执行语句,执行之后需要当天注册*/