Re: about limit

2007-03-20 Thread Peter Brawley
Remember, LIMITs are zero-based not 1-based. - Original Message - From: "nikos" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected Subject: about limit Hello list. Does any body knows how to select not the LIMIT

Re: about limit

2007-03-20 Thread Dan Buettner
n is a little exaggeration but you can other reasonably high numbers. Remember, LIMITs are zero-based not 1-based. - Original Message - From: "nikos" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected Subject: a

Re: about limit

2007-03-20 Thread nikos
D]> To: mysql@lists.mysql.com Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected Subject: about limit Hello list. Does any body knows how to select not the LIMIT 20 records but the rest of them? MySQL version is 4.1.21-standard and I cant make a VIEW. Thank you Nikos -- MySQL

Re: about limit

2007-03-20 Thread Rolando Edwards
2007 12:50:49 PM (GMT-0500) Auto-Detected Subject: about limit Hello list. Does any body knows how to select not the LIMIT 20 records but the rest of them? MySQL version is 4.1.21-standard and I cant make a VIEW. Thank you Nikos -- MySQL General Mailing List For list archives: http://lists

Re: about limit

2007-03-20 Thread Kevin Hunter
On 20 Mar 2007 at 12:50p -0400, nikos wrote: Does any body knows how to select not the LIMIT 20 records but the rest of them? MySQL version is 4.1.21-standard and I cant make a VIEW. In Venn-speak, you are asking for Circle A less(, minus, or subtract) Circle B. In SQL, this would transla

about limit

2007-03-20 Thread nikos
Hello list. Does any body knows how to select not the LIMIT 20 records but the rest of them? MySQL version is 4.1.21-standard and I cant make a VIEW. Thank you Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI