auto_increment

--=-XxgSdOwP9iT4J2GzRvu+
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

How do I reset the auto_increment value to 1 in table abc? Ron

--=-XxgSdOwP9iT4J2GzRvu+--

RE: auto_increment

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
>Reply-To: ron.php@actsministries.org
>To: PHP DB
>Subject: [PHP-DB] 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!1 47

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php