>> 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 I will remove
some records from the middle part o the table I will have holes, and
the next select will give me wrong data.

Regards,
Maciej Bobrowski

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to