I'm quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field..
Some rows have the same value for tag_in.. I'd like to neaten up the database in 2 ways:
1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp value..
2. Delete rows with duplicate tag_in but removing the one with the latest timestamp value..
How can i go about this ? Thank you for your help..
October 22, 2005 1:11 PM
October 22, 2005 3:55 PM