Re: LIMIT in MySQL

2002-11-26 Thread Rodney Broom
From: Jim Esten <[EMAIL PROTECTED]> > LIMIT is "LIMIT ,"...no? >From the 4.0.0-alpha docs, section 6.4.1: The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. If two arguments are given, the first spec

Re: LIMIT in MySQL

2002-11-26 Thread Steve Edberg
At 12:56 PM -0500 11/26/02, Mike At Spy wrote: I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 Thanks, -Mike As computers are wont to do, it's sendi

Re: LIMIT in MySQL

2002-11-26 Thread Ray
its not LIMIT from, to, its LIMIT start, count SELECT * FROM table ORDER BY somefield LIMIT 30,30 On Tuesday 26 November 2002 11:56, you wrote: > I must not be awake yet. Why is this query sending me back 60 records? > Shouldn't it only send back records 30 through 60 (i.e. 30 records)? > > SELE

Re: LIMIT in MySQL

2002-11-26 Thread Matthew Baranowski
Your command says select 60 rows starting at row 30. You want "LIMIT 30, 30" to get 30 rows. Matt - Original Message - From: Mike At Spy <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 9:56 AM Subject: LIMIT in MySQL > > I must no

RE: LIMIT in MySQL

2002-11-26 Thread Jennifer Goodie
:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: LIMIT in MySQL I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT

Re: LIMIT in MySQL

2002-11-26 Thread Benjamin Pflugmann
Hello. On Tue 2002-11-26 at 12:56:04 -0500, [EMAIL PROTECTED] wrote: > > I must not be awake yet. Why is this query sending me back 60 records? > Shouldn't it only send back records 30 through 60 (i.e. 30 records)? Because it's LIMIT , i.e. you are asking for rows 30-89 Bye, Benjam

RE: LIMIT in MySQL

2002-11-26 Thread Jim Esten
LIMIT is "LIMIT ,"...no? Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: LIMIT in MySQL I must not be awake yet. W

Re: LIMIT in MySQL

2002-11-26 Thread Paul DuBois
At 12:56 -0500 11/26/02, Mike At Spy wrote: I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 No. 30 = number of records to skip 60 = number of records

RE: LIMIT in MySQL

2002-11-26 Thread David Shanes
It is starting at record 30 and sending you the next 60 records. Maybe you want LIMIT 30, 30 ? David -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: LIMIT in MySQL I must not be awake yet. Why is

LIMIT in MySQL

2002-11-26 Thread Mike At Spy
I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 Thanks, -Mike - Before posting,