In message <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes
It's a shorthand way to say that I wanted to group on the first two
columns of my select statement.


Here's a quote from the manual: http://dev.mysql.com/doc/mysql/en/SELECT.html


Columns selected for output can be referred to in ORDER BY and GROUP BY
clauses using column names, column aliases, or column positions. Column
positions are integers and begin with 1:
mysql> SELECT college, region, seed FROM tournament
   ->     ORDER BY region, seed;
mysql> SELECT college, region AS r, seed AS s FROM tournament
   ->     ORDER BY r, s;
mysql> SELECT college, region, seed FROM tournament
   ->     ORDER BY 2, 3;
<<<

Since he had 3 columns in his SELECT clause but only the third one had an
aggregate function applied to it, I "grouped" on the other two. I could
have written it the long way as:

       GROUP BY _objectives.id, _objectives.name

Make sense?

[snip]
Yes, cheers. I shall make sure I avoid doing this, for readability's sake:-) Looks like a crunch / packing program has been set loose on it, like when wrote stuff on BBC's etc and crunched the code so it would fit:-)


But I get it.

I just love mySQL, it has removed so many layers of complication from my coding life.... and left only 1 layer of not too much complicatedness:-)

Site below is powered by mySQL.

M.
--
Mark Worsdall
http://www.vote4president.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to