innodb, auto increment columns and gaps in the sequence - how to handle ?

Hi all: I have various mysql tables (innodb type) where I am inserting values in auto increment columns. The value inserted into the auto increment columns is null which automatically means that the table handler inserts the next higher value in that column. Problem is, many of these updates ar

innodb, auto increment columns and gaps in the sequence - how to handle ?

Hi all: I have various mysql tables (innodb type) where I am inserting values in auto increment columns. The value inserted into the auto increment columns is null which automatically means that the table handler inserts the next higher value in that column. Problem is, many of these updates ar