Re: removing duplicate entries

You should be able to do it with the select you already have, something like this: delete ACCOUNTACTION from ACCOUNTACTION join ( select ACCOUNTACTION.ID from ACCOUNTACTION where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%' group by ACCOUNTACTION.ACCOUNT_ID having (count(ACCOUNTACTION.ACCOUNT

Re: removing duplicate entries

> >on A1.ID = U1.ID >where A1.ACTIONDATE like '2008-08-01 02:00%' >and U1.ID is NULL >) as D > ); > > Thanks for the pointers ;-) > > > > > -Original Message----- > From: Magnus Smith [mailto:[EMAIL PROTECTED] > Sen

RE: removing duplicate entries

10:35 To: Ananda Kumar Cc: mysql@lists.mysql.com Subject: RE: removing duplicate entries Yes I can see you are correct. I tried setting up a little test case myself. CREATE TABLE ACCOUNTACTION ( ID INT NOT NULL PRIMARY KEY, ACTIONDATE DATETIME, ACCOUNT_ID INT NOT NULL );

Re: removing duplicate entries

On Thu, Aug 7, 2008 at 2:34 AM, Magnus Smith <[EMAIL PROTECTED]> wrote: > Yes I can see you are correct. I tried setting up a little test case > myself. > > CREATE TABLE ACCOUNTACTION ( > ID INT NOT NULL PRIMARY KEY, > ACTIONDATE DATETIME, > ACCOUNT_ID INT NOT NULL > )

RE: removing duplicate entries

e '2008-08-01 02:00%' group by ACCOUNTACTION.ACCOUNT_ID having count(ACCOUNTACTION.ACCOUNT_ID) > 1 union select ACCOUNTACTION.ID, ACCOUNTACTION.ACCOUNT_ID from ACCOUNTACTION where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%' group by ACCOUNTACTION.ACCOUNT_ID having c

Re: removing duplicate entries

; > > -- > *From:* Ananda Kumar [mailto:[EMAIL PROTECTED] > *Sent:* 06 August 2008 10:11 > *To:* Magnus Smith > *Cc:* mysql@lists.mysql.com > *Subject:* Re: removing duplicate entries > > > I doubt the belwo sql will give you duplcates

RE: removing duplicate entries

8 10:11 To: Magnus Smith Cc: mysql@lists.mysql.com Subject: Re: removing duplicate entries I doubt the belwo sql will give you duplcates select ACCOUNTACTION.ID <http://accountaction.id/> from ACCOUNTACTION where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%' group by ACCO

Re: removing duplicate entries

I doubt the belwo sql will give you duplcates select ACCOUNTACTION.ID from ACCOUNTACTION where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%' group by ACCOUNTACTION.ACCOUNT_ID having (count(ACCOUNTACTION.ACCOUNT_ID) > 1 and ACCOUNTACTION.ID!=

RE: Removing duplicate entries

* Ville Mattila > I was wondering how would it be possible to delete those records from > database which has just same data? There can be also up to ten > copies of the record in database, and all but one should be deleted. > Do you have any easy way to do this? You could do it by creating a new

RE: Removing duplicate entries

Hi A long hand way to do this is use count to find out how many times this happens. Then use limit to one less than count? Hope this helps Simon -Original Message- From: Ville Mattila [mailto:[EMAIL PROTECTED]] Sent: 03 January 2002 15:03 To: [EMAIL PROTECTED] Subject: Removing duplicat

Re: Removing duplicate entries

Thank You so very much. Your way was great, fast and efficient. Here is my line of code: insert into sub2 (email,list_id) select email, list_id from subscribers; Thanks Again Steve Buehler At 03:31 AM 8/14/2001, you wrote: >I'd do it this way: > >insert into table table_new >select f