- 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 tran
auto_increment value suddenly increased from 20 to 32, and
the new row has 20 as series_id.
This leap seems to happen on every table.
What is the cause of the leap in auto_increment?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hi,
Is there any way to set the auto_increment value with the variable like
below.
mysql> set @id=10;
mysql> alter table suresh_copy auto_increme...@id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syn
. The problem is that I want to have new automatically generated
value back to insert it to another table. How can I have new
Auto_Increment value back at the same time I send NULL to it and it is gerenated
?
Regards,
Danesh
--
MySQL General Mailing List
For list archives: http
Auto_Increment value back at the same time I send NULL to it and it is
gerenated
?
Regards,
Danesh
Auto_Increment value back at the same time I
send NULL to it and it is gerenated ?
Regards,
Danesh
Gerben Gieling wrote:
Dear all,
I have an auto_increment value in an innodb table. I recently introduced
a new row by mistake and removed it. I beleive I read somewhere in the
manual that an innodb table does not reuse this number by default. I
also remember vaguely that it is possible to reset
Dear all,
I have an auto_increment value in an innodb table. I recently introduced
a new row by mistake and removed it. I beleive I read somewhere in the
manual that an innodb table does not reuse this number by default. I
also remember vaguely that it is possible to reset this next
autoincrement
Thank you, we shall investigate this problem.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
i believe since 3.23.39 it should not be?
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);
my
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
i believe since 3.23.39 it should not be?
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);
my
$recno LIMIT 1";
$result = mysql_query($query) or die("Error: ".mysql_error());
?>
-Original Message-
From: Zak Grant [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Next auto_increment value?
All,
I'm a
All,
I'm a little (lot!) stuck on generating what seems to be quite a simple
query...
Example:
I have a table with ID as auto_increment
It contains values 1 to 10
I delete #7
How can I, using MySQL, say "I have the number 6 - what's the next valid ID
up/down from this?"
I'm looking for, quite
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:
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.: 0608/974782
SMS: [EMAIL
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
19 matches
Mail list logo
