Page 1 of 1

How can I delete a duplicate row?

Posted: Tue Oct 27, 2009 2:17 am
by dilruk83
Here is my table.this table is creating automatically using for loop.Dont think about table just think about table data only.

id name age
1 a 24
1 b 25
2 c 20
2 d 21
3 e 19
3 f 19
1 a 24
1 b 25
2 c 20
2 d 21
3 e 19
3 f 19

I just want to delete or ignore duplicate rows when this table creating automatically.


Thank you..

Re: How can I delete a duplicate row?

Posted: Tue Oct 27, 2009 4:35 am
by Weiry
This was the very result of a "mysql delete duplicate rows" Google search.....................

Deleting Duplicate Rows in a MySQL Database

Remember, Google is your friend too.

Re: How can I delete a duplicate row?

Posted: Tue Oct 27, 2009 4:48 am
by dilruk83
Thank you


but i want to delete rows when table is creating.Coz those database values I'm getting from different tables.

Re: How can I delete a duplicate row?

Posted: Tue Oct 27, 2009 5:56 am
by Weiry