Spambusting: MySQL
> Richard,
>
> There has been talk of this before.
> (I haven't checked but) wouldn't be surprised if it's on the ToDo list
> - did you know that such info is available within the manual?
> If it's not, then propose such as a 'wish list'.
>
> Regards,
> =dn
>
> ----- Original Message -----
> From: "Richard Clarke" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: 04 March 2002 19:09
> Subject: Re: extra max() function possibly very useful?
>
>
> > Correct.
> >
> > Richard
> >
> >
> > ----- Original Message -----
> > From: "DL Neil" <[EMAIL PROTECTED]>
> > To: "Richard Clarke" <[EMAIL PROTECTED]>; "Christopher Thompson"
> > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Monday, March 04, 2002 6:34 PM
> > Subject: Re: extra max() function possibly very useful?
> >
> >
> > > LIMIT to be applied to each group result, instead of to the final
> > > resultset.
> > > Correct?
> > > =dn
> > >
> > >
> > > > Because that wouldn't give the correct results.
> > > > I want the top 5 rows for EACH id.
> > > ...
> > > > select distinct cid from mytable;
> > > > foreach(cid) {
> > > > select * from mytable where cid='$cid' order by hits desc
> limit 2;
> > > > }
> > > >
> > > > Which means the table is reread over and over. With this extra
> > > function we
> > > > could reduce the reads to at best once.
> > >
> >
> > SQL
> >
> >
>
> ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
