>-----Original Message----- >From: Hagen Finley [mailto:finha...@comcast.net] >Sent: Monday, February 23, 2009 11:41 AM >To: 'MySql' >Subject: Record IDs > >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? > [JS] If the table isn't too large, you might be able to
CREATE TABLE holder SELECT DISTINCT * FROM doubles [WHERE ...]; DELETE FROM doubles [WHERE ...] INSERT INTO doubles SELECT * FROM holder; >Hagen Finley >Boulder, CO > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
