mysql根据两个字段查询重复的记录
select * from user_activity group by user_id,activity_id having count(*) > 1
select * from white_list group by num_code,activity_id having count(*) > 1
select * from user_activity group by user_id,activity_id having count(*) > 1
select * from white_list group by num_code,activity_id having count(*) > 1