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]
