I was looking at my table in phpmyadmin and noticed that the id starts at 13410 and increase by 1. I would like to reset and start from one. I've read many people say its better to leave it alone or its going to get complicated if you messed with it but I still need a solution to at least start the id at 1. Thanks
ALTER TABLE table AUTO_INCREMENT = 1
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
I hope you know what you do!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With