> 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 > > > I'm assuming you inserted a new record after deleting record "3" and are wondering why it didn't reuse '3'. Yes. Auto-increment columns are frequently used to link tables in a relationship. If you "reused" '3' the associated records would think the originial record was still there not that a new one had been substituted.
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
