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..
How can I delete a duplicate row?
Moderator: General Moderators
Re: How can I delete a duplicate row?
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.
Deleting Duplicate Rows in a MySQL Database
Remember, Google is your friend too.
Re: How can I delete a duplicate row?
Thank you
but i want to delete rows when table is creating.Coz those database values I'm getting from different tables.
but i want to delete rows when table is creating.Coz those database values I'm getting from different tables.