Como Eliminar registros repetidos

[huesos52]

Con un ejemplo

Código mysql:

mysql> create table repetidos1(id integer,nombre text);
Query OK, 0 rows affected (0.01 sec)
 
mysql> insert into repetidos1 values(1,'daniel');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into repetidos1 values(1,'daniel');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into repetidos1 values(1,'daniel');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into repetidos1 values(2,'sara');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into repetidos1 values(2,'sara');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into repetidos1 values(2,'sara');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into repetidos1 values(2,'sara');
Query OK, 1 row affected (0.00 sec)
 
mysql> create temporary table repetidos2(id integer,nombre text);
Query OK, 0 rows affected (0.02 sec)
 
mysql> insert into repetidos2 select distinct id,nombre from repetidos1;
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0
 
mysql> select *from repetidos1;
+------+--------+
| id   | nombre |
+------+--------+
|    1 | daniel |
|    1 | daniel |
|    1 | daniel |
|    2 | sara   |
|    2 | sara   |
|    2 | sara   |
|    2 | sara   |
+------+--------+
7 rows in set (0.00 sec)
 
mysql> delete from repetidos1;
Query OK, 7 rows affected (0.02 sec)
 
mysql> insert into repetidos1 select *from repetidos2;
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0
 
mysql> select *from repetidos1;
+------+--------+
| id   | nombre |
+------+--------+
|    1 | daniel |
|    2 | sara   |
+------+--------+
2 rows in set (0.00 sec)
 
mysql>