update m set m=(case when m='男' then '女' else '男' end) where m<>''

select id, Count（*) from tb group by id having count(*)>1