Daniel, 'auto_increment' won't do that job for you and maybe it's not the right way to think about it anyway. You really only want to use 'auto_increment' for records that need to maintain serial numbers. If you are deleting records and wanting to use the 'deleted' number then your 'serial number' is not really associated with the record.
Best wishes, Paul Najman [EMAIL PROTECTED] ----- Original Message ----- From: "Daniel Crompton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 02, 2003 5:18 PM Subject: Why does auto increment not take into account deleted rows? > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]