From: Chetan Lavti <[EMAIL PROTECTED]> > 1. When I am inserting the values and the Query fails, the increment > should not took place and
It doesn't. > 2. When I delete a particular row from the table there should not be any > gap in the auto increment sequence. This doesn't work. Although you can drop and rebuild the column something like this (assuming that 'id' is the primary key): ALTER TABLE jack drop id; ALTER TABLE jack AUTO_INCREMENT=1, ADD id int unsigned not null auto_increment default '0', ADD primary key (id); --- Rodney Broom Programmer: Desert.Net --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php