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 an insert mysql inserts the new row somewhere in the
middle of the sequence. example
autoinc_field data_field
1 qwe
2 ert
3 ou
20 oiu
4 ngf
5 ljn
.
.
.
.
18 okj
19 thd
in my example the row 20 was inserted in the middle of the sequence
instead of inserting it in the last row.
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]