mysql查询所有记录,并去掉重复的记录 select * from tablename group by name;如果是select * from tablename group by name,age;那么查询的是满足name和age都不重复的记录。