I have created tables and deleted some rows and then inserted new rows. The IDs of the later created rows didn't start at 0 or 1. I dropped my entire database then recreated the same one with the same tables and fields. Unfortunately, newly entered rows started from where they were left at. For example, in the previous database, I had 9 rows in users table. After the database creation, the first row started at 10 instead of starting at 0 or 1. Now, I'd like to reset the auto-increment ID. Is there a way of resetting the ID after dropping and recreating a table with the same fields ?
I tried this line but it didn't work !! ALTER TABLE `users` AUTO_INCREMENT = 1;