in phpmyadmin, it displayed the results of 4000 duplicate entriesi have tried to delete them, with no luck...

any idea how to introduce some changes to the code, or inject another code to delete the duplicate entries (leaving one of them)

in simple examplethere is an two records (two rows) which shares different id, but both share exactly the duplicate contents including the columns vlauses (also dublicate) , time of the post (also dublicate) etc.. the only difference is the id only.

any idea please?

svcghost
—
2011-03-06T07:01:32Z —
#2

Yes. SELECT UNIQUE allows you to select only ONE record if there are two exact records. So just use UNIQUE keyword and delete those. You will thus be left with only 1 copy of each record.

Baitona
—
2011-03-06T09:10:05Z —
#3

thanks svcghost

sorry but i am not that mysql expert, do you mean i would need to delte the dublicate records one by one? I have 4000 records and will be lot of time, any chance for a little code to do that automatically, please?

svcghost said:

Yes. SELECT UNIQUE allows you to select only ONE record if there are two exact records. So just use UNIQUE keyword and delete those. You will thus be left with only 1 copy of each record.

P.Severy time i try deleting a record from the result of the above code