are you dumping the data or you just want to reset?
issuing the 'empty table' command in phpmyadmin will do that
or you can do
ALTER TABLE tbl AUTO_INCREMENT = 100;
bastien
From: Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx>
Reply-To: ron.php@xxxxxxxxxxxxxxxxxx
To: PHP DB <php-db@xxxxxxxxxxxxx>
Subject: auto_increment
Date: Sun, 11 Mar 2007 20:01:30 -0400
How do I reset the auto_increment value to 1 in table abc? Ron
_________________________________________________________________
This March Break, Have An Outdoor Fun-For-All!
http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!147
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
