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
