delete duplicates

[slighltywhacked]

Is it possible to get mysql to automaticly delete any duplicate rows

[tubedogg]

No.

[petesmc]

I asked the same question before, and found out that the real only way is to create a temperary table, and select Distinct from the previous one and insert into that tmp table, then empty the other one and import fomr the tmp table.

-Peter

[Defender1]

the best way to do that is prevention.
make it so your scripts check for that kinda stuff before it gets into the database so that you don't get dup's in the first place.

[D-flyer]

prevention with Unique in your mySQL might do the trick