Try truncate table. It essentially drops the table and recreates it. -- DVP
> -----Original Message----- > From: Arthur Radulescu [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 08, 2004 10:36 AM > To: [EMAIL PROTECTED] > Subject: autoincrement column > > Before switching to version 4.0.18 of MySQL the command "delete from > table" > was also reseting the autonincrement column value... It seems that this is > not happening anymore after we have installed this version... > > Any idee about this problem? Is there any other way to reset this? > > > Arthur > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]