Maciej Bobrowski <[EMAIL PROTECTED]> wrote:
>
> Let's say I have 1000 records in a 'table'. I want to select rows from 6
> to 11. How can I do this?
Use ORDER BY and LIMIT clauses:
http://www.mysql.com/doc/en/SELECT.html
--
For technical support contracts, goto https://order.mysql.com
Actually, this will *not* necessarily work. Without an ORDER BY
clause, the database is free to return records in any order; after
some deletions & insertions, your select below may return different
records, in a different order.
I would recommend adding an explicit record number to the table,
Maciej Bobrowski wrote:
Let's say I have 1000 records in a 'table'. I want to select rows from 6
to 11. How can I do this?
SELECT * FROM tablename where column>5 AND column<12;
No, no. I have no numerical fileds in the table. Your example is not good.
Even if I could add the 'id' column to the
O.K. I found the way:
select * from tablename limit 5,6;
it will select 6 records counting from 6.
>> Let's say I have 1000 records in a 'table'. I want to select rows from6
>> to 11. How can I do this?
> SELECT * FROM tablename where column>5 AND column<12;
Best regards,
Maciej Bobrowski
-
SELECT * FROM tablename LIMIT 5, 6
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Maciej Bobrowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday
>> Let's say I have 1000 records in a 'table'. I want to select rows from 6
>> to 11. How can I do this?
> SELECT * FROM tablename where column>5 AND column<12;
No, no. I have no numerical fileds in the table. Your example is not good.
Even if I could add the 'id' column to the table, then when
SELECT * FROM tablename where column>5 AND column<12;
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 18:26、Maciej Bobrowski さんは書きました:
> Hi,
>
> Let's say I have 1000 records in a 'table'. I want to select rows from 6
> to 11. How can I do this?
>
>
> Regards,
> Maciej Bobrowski
--
--
Hi,
Let's say I have 1000 records in a 'table'. I want to select rows from 6
to 11. How can I do this?
Regards,
Maciej Bobrowski
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
