"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,
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.
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
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
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?
Thanks.
Hassan
Hi,
How do I reset the RTID to the last-highest-number?
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---
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 rese
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
> Sent: Wednesday, July 09, 2003 12:08 PM
> To: [EMAIL PROTECTED]
> Subject: RESETTING AUTO_INCREMENT
>
>
>
> Hi everyone:
>
> Does anyone know how to reset the auto_increment value of
> certain table.
>
> Any ide
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> __
Hi everyone:
Does anyone know how to reset the auto_increment value of certain table.
Any ideas or sugestions
Greetings in advance
_
Únete al mayor servicio mundial de correo electrónico:
http://www.hotmail.com
--
MySQL General
13 matches
Mail list logo
