2009/2/23 Hagen Finley <finha...@comcast.net>: > I have a number of duplicate records in my table which are identical hence, > I can't do a delete on the columns without deleting both records. One > deletion strategy I have considered is identifying the records by their > table record id - but I don't know for certain that such an identifier > exists or how I would show it via a select statement. Any suggestions?
DELETE FROM yourtable WHERE foo=bar LIMIT 1 should do the job. Greetings, Mattia Merzi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org