Re: Anyway to reset MySql's AUTO_INCREMENT counter?
| From: | Alexander Skwar | Date: | Thu, 26 Jul 2001 17:31:45 +0000 |
| Subject: | Re: Anyway to reset MySql's AUTO_INCREMENT counter? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-59799@lists.php.net to get a copy of this message | ||
So sprach »elias« am 2001-07-26 um 11:43:36 +0200 :
> Can't I reset that pointer w/ deleting the table and creating it again?
Yep, DELETE FROM Table instead of dropping it.
Or did you mean w/o?
ALTER TABLE Table auto_increment=234;
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 3 days 18 hours 14 minutes