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
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
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
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 not be awake yet. Why is this
Read the documentation.
http://www.mysql.com/doc/en/SELECT.html
The link has been sent out on this list about 6 times this morning, all in
posts regarding the limit clause.
The LIMIT clause can be used to constrain the number of rows returned by the
SELECT statement. LIMIT takes one or two numeri
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
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. Why is this qu
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
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
