RE: [PHP-DB] Resetting MySQL Auto_Index - How?
| From: | Beau Lebens | Date: | Thu, 25 Jul 2002 05:41:08 +0000 |
| Subject: | RE: [PHP-DB] Resetting MySQL Auto_Index - How? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20771@lists.php.net to get a copy of this message | ||
monty,
i found that if you do the command
DELETE FROM table
(with no WHERE clause) it deletes everything, and resets
Beau
// -----Original Message-----
// From: Monty [mailto:monty3@hotmail.com]
// Sent: Thursday, 25 July 2002 1:34 PM
// To: php-db@lists.php.net
// Subject: [PHP-DB] Resetting MySQL Auto_Index - How?
//
//
// Is there a way to re-set the internal counter that
// automatically increments
// "auto_increment" fields? While testing an app, I added a lot
// of test records
// that I've deleted, so, I'd like to reset the counter back to
// the beginning
// now.
//
// Thanks.
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//