auto_increment counter changes even if query fails

Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO test

Re: auto_increment counter changes even if query fails

Maciek, Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO

Re: auto_increment counter changes even if query fails

Maciek, Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO

Re: auto_increment counter changes even if query fails

Maciek, Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO

Re: auto_increment counter changes even if query fails

Maciek, Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO

Re: auto_increment counter changes even if query fails

Maciek, Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO

Re: auto_increment counter changes even if query fails

Maciek, Hi, Is this correct for MySQL to increment the auto_increment counter if the INSERT query fails? For example: mysql CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql INSERT INTO