Hi,

Because of deleted rows, I need to renumber my auto_increment column. The book by Paul Dubois shows two methods, neither of which work for me.

One drops the field and then adds it back in. This works, however it breaks all of my queries because it adds the field back in as the last one in the table.

The other errors out at me about format.

here is a simple dump of a table I'm using:

mysql> describe email_agent; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | int(5) | | PRI | 0 | auto_increment | | email | varchar(40) | | UNI | | | | format | varchar(6) | | | | | | password | varchar(10) | | | | | | service | varchar(8) | | | | | +----------+-------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)

When I do the renumbering, th id field needs to maintain its position.

thanks,