Hi, My understanding is that with mysql >= 3.23 versions the last value of an auto_increm column is stored, thus even if records are deleted, when a new one is inserted (as NULL), values will not be re-used. This is a fine attribute, but is there any way to override it? That is, to bump back the counter by force?
E.g. I have test: 1 2 3 4 and then delete "3" and "4": 1 2 and when inserting a new record by saying "insert into test NULL" , I would like it to become "3". Maybe I need a new table creation, and copy of current table in that, etc.? Cheers Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]