Hello all again.
I think I need to be a little more specific in describing my problem.
So, let me try again. I have a database of scrap records. There are
currently over 2000 records in this database. I have a web page that
queries this database and displays the records in reverse order, newest
isn't it as simple as...
select id,lot_id,lot_type from scrap_table
where id >= 1932 and id <= 1942
order by id limit 10;
?
cheers,
P
>
> which should give me records 1932 - 1942 like this...
>
> +--+--+--+
> | id | lot_id | lot_type |
> +--+
> select id,lot_id,lot_type from scrap_table
> (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|
>
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
