Re: MySQL Query Puzzle

Peter wrote:

Hi All, I have a table which contain's some duplicate rows. I just want to delete the duplicate records alone not original records. Assume my table as look as below column1 column2 1

    a

1

    a

2

    b

3

    c

3

    c

i want the above table need to be as below, After executing the mysql query. column1

    column2

1

    a

2

    b

3

    c

Thanks in advance.. Regards Peter

Use the SQL command alter with the ignore flag. ALTER IGNORE TABLE your_table ADD UNIQUE ( column1 , column2 ) I tested this on my test DB and it worked fine. It erased all the duplicates and left one instance of the multiple entry values. This will add a permanent unique restraint to the table. So, you will never have dupps again. Jim Lucas