--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> Well I think this is mostly working. I have a 'NULL' user ID which is > 'system' that I need to get into here, but I think I'm mostly on > track... > > There are lots of ways to accomplish this task it seems. ALL of which > would > be so much easier if mySQL would just return all the data from the > same > MAX() row it just pulled. I really don't see why this has to be so > complicated. I appreciate in some ways that mySQL tries to be "nice" > and > give me some data, but what good is it if it's WRONG?! Either throw > an > error, so I make a proper query, or else give me what I wanted... > *sigh* I agree, it should throw an error. > Is there EVER a time when someone wants the behaviour of mySQL now? I > can't > for the life of me think of a case. When it comes to this particular behavior, I agree that it is flawed. However, there is WAY too much code out there to just turn it off. This is definitely a migration/training issue as well as a parser issue now. > This page had some more info: > http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html > <snip> I am so glad the fine manual was useful for you. I think that everyone should review the techniques discussed not just in the article you quoted but also in the articles around it. Shawn Green Database Administrator __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]