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 can
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 Mailing
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, simply use
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 table_name AUTO_INCREMENT = new_value;
Any suggestions for InnoDB?
Insert a row with a custom
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_Increment
On Mon, 12 Jan 2004, Hassan Shaikh
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
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
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
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
