Re: Resetting auto_increment field in an INNODB table

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

Re: Resetting auto_increment field in an INNODB table

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

Re: Resetting auto_increment field in an INNODB table

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

Resetting auto_increment field in an INNODB table

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: