update bi_t_item_info set flag2='N' where len(item_subno)>5 and flag2 in ('Z','J')

N代表普通,Z,J代表计重和计数