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
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:
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?
Thanks.
Hassan
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
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 reset
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
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
: 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 ideas or sugestions
Greetings in advance
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
13 matches
Mail list logo