At 4:10 +0700 2/11/02, Steven Haryanto wrote:
>i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
>
>mysql> create table t1_b(i int unsigned primary key auto_increment,
>j int) type=bdb;
>mysql> create table t1_m(i int unsigned primary key auto_increment,
>j int) type=myisam;
>mysql> insert into t1_bdb(j)values(0);
>mysql> insert into t1_bdb(j)values(0);
>mysql> insert into t1_bdb(j)values(0);
>mysql> select * from t1_bdb;
>+---+------+
>| i | j |
>+---+------+
>| 1 | 0 |
>| 2 | 0 |
>| 3 | 0 |
>+---+------+
>3 rows in set (0.00 sec)
>
>mysql> delete from t1_bdb where i=3;
>mysql> insert into t1_bdb(j)values(0);
>mysql> select * from t1_bdb;
>+---+------+
>| i | j |
>+---+------+
>| 1 | 0 |
>| 2 | 0 |
>| 3 | 0 |
>+---+------+
>3 rows in set (0.00 sec)
>
>mysql> insert into t1_myisam(j)values(0);
>mysql> insert into t1_myisam(j)values(0);
>mysql> insert into t1_myisam(j)values(0);
>mysql> select * from t1_myisam;
>+---+------+
>| i | j |
>+---+------+
>| 1 | 0 |
>| 2 | 0 |
>| 3 | 0 |
>+---+------+
>3 rows in set (0.00 sec)
>
>mysql> delete from t1_myisam where i=3;
>mysql> insert into t1_myisam(j)values(0);
>mysql> select * from t1_myisam;
>+---+------+
>| i | j |
>+---+------+
>| 1 | 0 |
>| 2 | 0 |
>| 4 | 0 |
>+---+------+
>
>--
>sh
>
>
>---------------------------------------------------------------------
>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 <mysql-thread99084@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
