;Fletcher Sandbeck" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 3:04 PM
Subject: RE: Getting Found Count When Using Limit
> * Fletcher Sandbeck
> > Actually, easy thing to do through the APIs or most third-party
> > languages that let you access MySQL. I'm
* Fletcher Sandbeck
> Actually, easy thing to do through the APIs or most third-party
> languages that let you access MySQL. I'm looking for a way to
> do it using raw MySQL statements.
>
> I think I found my answer in the list archives. It's not
> possible without using multiple SQL statements.
On 3/21/02 at 12:51 PM, Allon Bendavid wrote:
> Tough thing to do. Fortunately we thought this through for you in jTalk.
> Keep your eyes peeled for a formal announcement next week.
Actually, easy thing to do through the APIs or most third-party languages that
let you access MySQL. I'm looking
Tough thing to do. Fortunately we thought this through for you in jTalk.
Keep your eyes peeled for a formal announcement next week.
-Allon
On 3/21/02 11:04 AM, "Fletcher Sandbeck" <[EMAIL PROTECTED]> wrote:
> I am trying to get the full found count from a query while using LIMIT to
> return
>
I am trying to get the full found count from a query while using LIMIT to return
just a portion of the found records. I can use two queries in a row to get
first the found count, then the found records, but that takes twice as long as
performing either query by itself.
SELECT COUNT(*) FROM datab
