I have a little problem with database, charge the regisrtos from xls and can load more than two vcese the same xls generating duplicate records, I can not restrict that are unique because they are records that are repeated in several columns ... I meuestro them
id| Fecha | EquipoA | EquipoB | Categoria | Cancha | Hora | Nr_J1 | Nombre_J1 | Apellido_J1 | Nr_J2 | Nombre_J2 | Apellido_J2
1 |Sáb 09 Abr | San Juan | Edu | sub18 | San Juan | 15:00 | 39 | A. | Aunchayna | 95 | S. | Villizio
2 |Sáb 09 Abr | San Juan | Impulso | sub16 | San Juan | 16:30 | 39 | A. | Aunchayna | 95 | S. | Villizio
3 |Sáb 09 Abr | San Juan A| ISASA | sub16 | San Juan | 18:00 | 39 | A. | Aunchayna | 95 | S. | Villizio
4 |Sáb 09 Abr | San Juan | ISASA | sub14 | San Juan | 19:30 | 39 | A. | Aunchayna | 95 | S. | Villizio
5 |Sáb 09 Abr | San Juan | Edu | sub18 | San Juan | 15:00 | 39 | A. | Aunchayna | 95 | S. | Villizio
this is an example register 1 is equal to 5 in all columns, but others differ in EquipoA or EquipoB or Hora... so I can not make them be unique
I need to clear the log is repeated in this case 5 and leave 1 I'm no expert in MySql and I was very difficult to find the right query
Aucun commentaire:
Enregistrer un commentaire