MySQL: Updating ID auto_increment fields
| From: | Tom Churm | 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