select id,lot_id,lot_type from scrap_table where id >= 1932 order by id
limit 10;
select id,lot_id,lot_type from scrap_table order by id limit 1932,10;
either should work, i think the first would be faster but I'm not positive
how MySQL would handle the second in terms of optimization.
-jm
-----Original Message-----
From: Ron Beck [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 8:23 AM
To: [EMAIL PROTECTED]
Subject: Display information
Hello all,
I have a database with a little over 2000 records. I want to be able to
construct a query that says something like this...
select id,lot_id,lot_type from scrap_table
<starting with record 1932> (part I need help with)
order by id limit 10;
which should give me records 1932 - 1942 like this...
+------+----------+----------+
| id | lot_id | lot_type |
+------+----------+----------+
| 1942 | 0034906 | F |
| 1941 | 0100308 | F |
| 1940 | 0036309 | S |
| 1939 | 0033503 | F |
| 1938 | 0034108E | D |
| 1937 | 0034712 | F |
| 1936 | 0029404 | F |
| 1935 | 0032706 | F |
| 1934 | 0029404 | F |
| 1933 | 0100307 | F |
| 1932 | 0100404 | F |
+------+----------+----------+
any suggestions?
Ron
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
