"Chris Boget" <[EMAIL PROTECTED]> wrote:
>> > How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
>> > the method mentioned in the manual is not applicable. I am using MySQL
>> > 4.0.17.
>> Otherwise you should recreate the table.
>
> Or, if you no longer need any of the data, sim
> > How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
> > the method mentioned in the manual is not applicable. I am using MySQL
> > 4.0.17.
> Otherwise you should recreate the table.
Or, if you no longer need any of the data, simply use TRUNCATE.
Chris
--
MySQL General Mail
"Hassan Shaikh" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
> the method mentioned in the manual is not applicable. I am using MySQL
> 4.0.17.
If you want to start auto_increment sequence with value bigger than current counter
value,
You got to be kidding! I am sure there's a better solution.
Hassan
- Original Message -
From: "Tobias Asplund" <[EMAIL PROTECTED]>
To: "Hassan Shaikh" <[EMAIL PROTECTED]>
Cc: <
Sent: Monday, January 12, 2004 9:43 PM
Subject: Re: Resetting Auto_I
On Mon, 12 Jan 2004, Hassan Shaikh wrote:
> Hi,
> The following does not work for InnoDB tables. The manual says "The next
> AUTO_INCREMENT value you want to set for your table (MyISAM). "
> ALTER TABLE AUTO_INCREMENT = ;
>
> Any suggestions for InnoDB?
Insert a row with a custom value, then de
Or drop and recreate the table (that's actually what truncate is doing)
/rudy
-Original Message-
From: Miguel Perez [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 20:08
To: [EMAIL PROTECTED]
Subject: RESETTING AUTO_INCREMENT
Hi everyone:
Does anyone know how to reset the auto_in
hi mike
you suggested the following
> If you are referring to recovering some auto_increment values that were previously
> used by no rows now use > them, it is better to avoid this.
how can you prevent this?
best regards
benny
Why are you looking to reset it? If you mean resetting when there is no data in a
table, a truncate table should start the auto_increment over again. If you are
referring to recovering some auto_increment values that were previously used by no
rows now use them, it is better to avoid this. That
Miguel:
Wednesday, July 9, 2003, 3:07:33 PM, você escreveu:
---[inicio]--
MP> Hi everyone:
MP> Does anyone know how to reset the auto_increment value of certain table.
MP> Any ideas or sugestions
MP> Greetings in advance
MP> __
