mysql 4.0.2 preoblem

[Cres Justado]

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]