Rich <[EMAIL PROTECTED]> wrote on 03/30/2006 09:11:56 PM: > Hi there. Any quick way of killing duplicate records? > > Cheers >
Yes. Some ways involve subqueries, others temporary tables. What version are you on? What are your table definition(s) (use SHOW CREATE TABLE to dump the defs)? How do your define "duplicate" for the table(s) you are having problems with? More details will get you better answers ;-) Shawn Green Database Administrator Unimin Corporation - Spruce Pine