MySQL: Updating ID auto_increment fields

From: Date: Mon, 27 Aug 2001 14:08:02 +0000
Subject: MySQL: Updating ID auto_increment fields
Groups: php.general 
Request: Send a blank email to php-general+get-64635@lists.php.net to get a copy of this message
howdy, this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: "id int(10) unsigned NOT NULL auto_increment," now, when i have to clean up items in my tables, like when users have sent off a .html form multiple times and i want to delete duplicate submissions, how can i quickly & easily update all of the 'id' fields in the entire table, to reflect the numeration change? now, using phpmyadmin, if i go in and delete a few entries, the id's have gaps in them.. mucho gracias, tom

« previous php.general (#64635) next »