Removing Dupe SQL Entries/Rows..

[Gut]

Is there anyway to remove duplicate SQL rows (For player_skills). Everyone's skills on my server have been trippled (They show up 3x each on highscores).

Any ideas?

 

[xxgoosexx]

SELECT player_id,skillid,value,count
FROM player_skills
Group By player_id,skillid,value,count
Having Count(*) >= 1

then export that selection and import into an empty player_skills table

 

[Gut]

tZomg u are the man! no one else could figure this out! goose = god.

 

[corporatelayer]

how to I import and export the data to the clean table?