List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 10 2002 10:21pm
Subject:Re: auto_increment value recycled/reset in BDB table? [3.23.46]
View as plain text  
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

Thread
auto_increment value recycled/reset in BDB table? [3.23.46]Steven Haryanto10 Feb
  • Re: auto_increment value recycled/reset in BDB table? [3.23.46]Paul DuBois10 Feb
    • Re: auto_increment value recycled/reset in BDB table? [3.23.46]Steven Haryanto11 Feb
      • Re: auto_increment value recycled/reset in BDB table? [3.23.46]Paul DuBois11 Feb
Re: auto_increment value recycled/reset in BDB table? [3.23.46]Steven Haryanto12 Feb