I have one column as an auto increment for adding numbers:

1
2
3
4
5

If i delete row 3 then add a new row and view the results i get:

1
2
4
5
6

As you can see 3 has been deleted and its now added 6!

Is this normal?.  How can i get it to always display numbers in this column
in sequence.
TIA




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to