your query is: DELETE FROM mytable; -----Original Message----- From: Claudiu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 5:09 AM To: [EMAIL PROTECTED] Subject: [PHP] reset auto_increment field mysql
I have a mysql table which contains an id field which is set to auto_increment. I have a script which empties this database at regular intervals. My problem is that the auto_increment field won't reset to 0 after deleting all of tha data, but continue incrementing from where it left. How can i solve this problem.. I want id to reset to 0 when i delete the contents of the table. Can someone help? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php