MySQL queries all records and removes duplicate records

The distinct (STR) function is used to remove duplicate records, but it is only possible to repeat for a certain field. For example: SELECT DISTINCT (name) from TableName; However, if you want to query the records of other field values, I started thinking about using select DISTINCT (name), ta.* from TableName. Note that distinct must be placed in front! But this did not remove the duplicate records, and later thought of group by. So, if you want to get rid of the duplicate records of a field in the table, and query out the values of all the fields. So just write it OK, for example: SELECT * FROM tablename group by name; if SELECT * FROM tablename GROUP by Name,age, then the query is a record that satisfies both name and age.

MySQL queries all records and removes duplicate records