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]