If you want them ordered by autoinc_field then add
ORDER BY autoinc_field.
Otherwise expect them to be returned in any order.
Cres Justado wrote:
can anyone help me with my problem regarding mysql 4.0.2. I'm having a
problem with the sequencing of the auto incremnt field. if my
application makes
That's how dbs work. When rows are deleted, they reclaim that space when
new rows are inserted. Hence, there is no "last row" (in fact, no order at
all) unless you explicitly order the results in your select. That's what
ORDER BY is for. Try
SELECT autoinc_field, data_field FROM yourtable
