CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name;
DROP TABLE old_name; ALTER TABLE new_name RENAME TO old_name; On 2005-11-04 17:15, Peter Atkins wrote:
All,I have a duplicate row problem and to make matters worse some tables don't have a PK or any unique identifier.Anyone have any thoughts on how to remove dups?
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
