- Original Message -
> From: "crocket"
>
> I had 19 rows in series table. And when I tried inserting the 20th
> row, the auto_increment value suddenly increased from 20 to 32, and
> the new row has 20 as series_id.
The first thing that comes to mind, is transactions that insert, but then
http://dev.mysql.com/doc/refman/4.1/en/odbc-and-last-insert-id.html
|
| Cal Evans
| http://www.calevans.com
|
Danesh Daroui wrote:
Hi all,
I have a simple table with an Auto_Increment column. I insert NULL
to this column each time I insert a row to have an automatic unique
value. Th
Thank you, we shall investigate this problem.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
At 11/02/2002 05:21, Paul DuBois wrote:
>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.
i see, so this is an "undocumented feature" (i haven't seen this
in http
At 11/02/2002 05:21, Paul DuBois wrote:
>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.
i see, so this is an "undocumented feature" (i haven't seen this
in http
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
Refer to the man page for myisamchk
ryan
> Hi,
>
> how I can change AUTO_INCREMENT value for one concrete table in mysql
> database? (e. g., this value you can get from 'show table status'). Thanx!
>
> oSup
>
>
>
> e-mail: [EMAIL PROTECTED]
> ICQ: 10798264
> tel.: 06
Hi,
how I can change AUTO_INCREMENT value for one concrete table in mysql
database? (this value
you can get from 'show table status'). Thanx!
oSup
e-mail: [EMAIL PROTECTED]
ICQ: 10798264
tel.: 0608/974782
SMS: [EMAIL PROTECTED]
