[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: Help with subqueries... MAX() and GROUP BY [sovled]
From:       Shawn Green <sgreen_mysql () yahoo ! com>
Date:       2006-04-29 13:45:40
Message-ID: 20060429134540.32534.qmail () web38605 ! mail ! mud ! yahoo ! com
[Download RAW message or body]



--- Daevid Vincent <daevid@daevid.com> 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/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]