Re: auto_increment counter changes even if query fails

2001-11-12 Thread Heikki Tuuri
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> INS

Re: auto_increment counter changes even if query fails

2001-11-12 Thread Heikki Tuuri
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> INS

Re: auto_increment counter changes even if query fails

2001-11-12 Thread Heikki Tuuri
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> INS

Re: auto_increment counter changes even if query fails

2001-11-12 Thread Heikki Tuuri
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> INS

Re: auto_increment counter changes even if query fails

2001-11-12 Thread Heikki Tuuri
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> INS

Re: auto_increment counter changes even if query fails

2001-11-12 Thread Heikki Tuuri
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> INS