How to remove duplicate records in mysql?

Question

MySQL

Hello. There is such table:

When testing superfluous repeating records. How to remove them?
What I mean by repetitive. These are the lines where id_user, id_contact and type_contact can be repeated in the database.
Those.
1,1,2,0;
2.1.3.0;
3.1.2.0;
The first and third lines are repeated. And they need to be deleted or at least get an id.

Answer 1

ok e y g y g l (yes, each letter is a different link )

Answer 2

DISTINCT
you do sELECT DISTINCT, you insert it into another tabla, you bang this one