MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: I thisk I got it! It is possible, even *with* a subquery!
Posted by: dump3
Date: July 27, 2005 08:35AM

I've been trying the earlier solutions with a copy of the table (about 500,000 records). It's languishing. I've yet to be able to put any records into the hold table.

Previously, I always seemed to run into a problem with getting a distinct name AND IP.

I've now added a new field, name_ip to the table with a concat version of name and ip, for example:

"johndoe:2.3.4.5"

Will this help? Can I do a DISTINCT with some sort of MAX running_time combo? Or does this not buy us anything?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How do I delete all but most recent record?
dump3
July 25, 2005 08:36AM
Re: How do I delete all but most recent record?
Andrew Gilfrin
July 25, 2005 09:28AM
Re: How do I delete all but most recent record?
dump3
July 25, 2005 10:33AM
Re: How do I delete all but most recent record?
Christian Hamel
July 25, 2005 10:13AM
Re: How do I delete all but most recent record?
dump3
July 25, 2005 10:39AM
Re: How do I delete all but most recent record?
Andrew Gilfrin
July 25, 2005 03:46PM
Re: How do I delete all but most recent record?
dump3
July 25, 2005 06:34PM
Re: How do I delete all but most recent record?
Christian Hamel
July 26, 2005 05:52AM
Re: How do I delete all but most recent record?
dump3
July 26, 2005 07:37AM
Re: How do I delete all but most recent record?
Roland Bouman
July 26, 2005 06:11AM
Re: How do I delete all but most recent record?
dump3
July 26, 2005 07:38AM
Re: How do I delete all but most recent record?
dump3
July 26, 2005 07:55AM
Re: How do I delete all but most recent record?
Roland Bouman
July 26, 2005 08:09AM
Re: How do I delete all but most recent record?
Roland Bouman
July 26, 2005 12:10PM
Re: How do I delete all but most recent record?
Felix Geerinckx
July 26, 2005 02:00PM
Re: How do I delete all but most recent record?
Roland Bouman
July 26, 2005 04:23PM
Re: How do I delete all but most recent record?
dump3
July 26, 2005 05:51PM
Re: How do I delete all but most recent record?
Roland Bouman
July 26, 2005 06:05PM
Re: How do I delete all but most recent record?
Felix Geerinckx
July 28, 2005 05:34AM
I thisk I got it! It is possible, even *with* a subquery!
Roland Bouman
July 27, 2005 01:59AM
Re: I thisk I got it! It is possible, even *with* a subquery!
dump3
July 27, 2005 08:35AM
Re: I thisk I got it! It is possible, even *with* a subquery!
Roland Bouman
July 27, 2005 08:42AM
Re: I thisk I got it! It is possible, even *with* a subquery!
Roland Bouman
July 27, 2005 08:43AM
Re: I thisk I got it! It is possible, even *with* a subquery!
dump3
July 27, 2005 08:48AM
Re: I thisk I got it! It is possible, even *with* a subquery!
Roland Bouman
July 27, 2005 09:22AM
Re: I thisk I got it! It is possible, even *with* a subquery!
dump3
July 27, 2005 09:54AM
Re: I thisk I got it! It is possible, even *with* a subquery!
dump3
July 27, 2005 11:24AM
Re: I thisk I got it! It is possible, even *with* a subquery!
dump3
July 27, 2005 12:05PM
Re: I thisk I got it! It is possible, even *with* a subquery!
Roland Bouman
July 27, 2005 12:11PM
Re: I thisk I got it! It is possible, even *with* a subquery!
dump3
July 27, 2005 12:46PM
Re: I thisk I got it! It is possible, even *with* a subquery!
Roland Bouman
July 27, 2005 01:16PM
Re: I thisk I got it! It is possible, even *with* a subquery!
Erin ONeill
July 29, 2005 03:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.