Delete duplicates from a table

[SystemJay]

Hi,

I have the following table, but I dont seem to be able to remove the duplicates.



table: coordinates

auto
incrementing
ID | auto | X | Y | Z |
-------------------------------------------------------
1 17 1 2 2
2 17 1 2 2
3 17 1 2 2
4 17 1 3 8
5 17 1 3 8
6 17 1 7 1
7 17 1 7 1
8 17 1 7 1
9 17 1 4 3
10 17 1 4 3



What I'd need is the table to be transformed into similar
(only one row of the one coordinate aka remove doubles
or triples or quardos etc if there are such):



table: coordinates

auto
incrementing
ID | auto | X | Y | Z |
---------------------------------------------------
1 17 1 2 2
4 17 1 3 8
6 17 1 7 1
9 17 1 4 3



Could someone give me a hand with this mySQL query? Thanks a ton. :D

[SystemJay]

Ah tried to approach it in a different way...
This one works like a charm, and needs no continous queries.

ALTER IGNORE TABLE coordinates ADD UNIQUE INDEX(auto,X,Y,Z);