I've been asked this numerous times, so I decided to post it. If you are databasing and find yourself either clearing your table, or moving a databased program from site to site, you may notice that clearing the table out does not reset the PRIMARY ID (UNIQUE ID), also known as auto increment, number. Execute this SQL to reset that number. Of course, you can change the number 1 to whatever you would like. So, if you want your ID to start at 10,000 use 10000. Cheers!
[code]ALTER TABLE tablename AUTO_INCREMENT = 1
Comments
» No Comments have been made on this. How about you start us off?
Comment On This
Comments Have Been Disabled.
Browse By Category
- All Posts
- Useful Websites
- Money Savers
- Tips And Tricks
- Social Media
- Guides and Information
- PHP
- How-Tos
Latest Posts
- » Easily Open A TCP Port On Your Stock cPanel Server
- » Free Code: Find The Total Line Count Of A Folder Using PHP
- » Free Code: ReCaptcha Form Validation With PHP
- » Stop Cron Jobs From Automatically Sending You Emails
- » View All
