RE: [PHP-DB] auto_increment
| From: | Bastien Koert | Date: | Mon, 12 Mar 2007 00:06:01 +0000 |
| Subject: | RE: [PHP-DB] auto_increment | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43244@lists.php.net to get a copy of this message | ||
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@actsministries.org> Reply-To: ron.php@actsministries.org To: PHP DB <php-db@lists.php.net> 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!147