phpMyAdmin--resetting auto increments to 0

From: Date: Sun, 16 Apr 2006 06:46:25 +0000
Subject: phpMyAdmin--resetting auto increments to 0
Groups: php.general 
Request: Send a blank email to php-general+get-234059@lists.php.net to get a copy of this message
hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex

« previous php.general (#234059) next »