select (@i:=@i+1) i, identity,bnumber from unicom_data,(SELECT @i:=0) as i where channel =‘武功乡’
DELETE FROM unicom_data WHERE channel = ‘666’
select (@i:=@i+1) i, identity,bnumber from unicom_data,(SELECT @i:=0) as i where channel =‘武功乡’
DELETE FROM unicom_data WHERE channel = ‘666’