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 way you can prevent some potential conflicts.
You can reset the auto_increment with ALTER TABLE tablename AUTO_INCREMENT = 1; but know what you are doing when you do. Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Miguel Perez [mailto:[EMAIL PROTECTED] > 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 ideas or sugestions > > Greetings in advance > > _________________________________________________________________ > Únete al mayor servicio mundial de correo electrónico: > http://www.hotmail.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
