At 1:52 +0200 3/18/04, Lorderon wrote:
Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but
only 1 row is returned from that query always.. I want MySQL to stop the
count when it reaches to 200, rather to have it go over all the table and
return me 3500..
You can't tell COUN
Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but
only 1 row is returned from that query always.. I want MySQL to stop the
count when it reaches to 200, rather to have it go over all the table and
return me 3500..
> SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
-Original Message-
From: Lorderon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 6:45 PM
To: [EMAIL PROTECTED]
Subject: limit stop count
How can I limit a count to stop when he reaches 200 rows?
SELECT COUNT(*) FROM tbl W
