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
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 an insert mysql inserts the new row somewhere in the middle of the
sequence. example
autoinc_field data_field
1 qwe
2
