Re: Delete Duplicates

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

Re: Delete Duplicates

Subquries will help you . --Praj On Thu, 30 Mar 2006 21:11:56 -0500 Rich <[EMAIL PROTECTED]> wrote: > Hi there. Any quick way of killing duplicate records? > > Cheers > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: Delete Duplicates

Rich wrote: Hi there. Any quick way of killing duplicate records? Cheers Subqueries probably. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co