查询user表中,user_name字段值重复的数据及重复次数
select user_name,count(*) as count from user group by user_name having count>1;
mysqldump 备份导出数据排除某张表
原文:http://www.cnblogs.com/kccdzz/p/7735485.html