Re: limit stop count

2004-03-17 Thread Paul DuBois
tmp; DROP TABLE tmp; 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? SE

Re: limit stop count

2004-03-17 Thread Lorderon
imit 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(*) F

RE: limit stop count

2004-03-17 Thread Rogers, Dennis
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

limit stop count

2004-03-17 Thread Lorderon
How can I limit a count to stop when he reaches 200 rows? SELECT COUNT(*) FROM tbl WHERE where_clause;=> returns 3500 I want to stop the counting when it reaches to 200, so MySQL will not search further to count all the 3500 rows.. thanks, -Lorderon. -- MySQL General Mailing List For li