?
Solved

How to reset an auto_increment column to 0 using phpMyAdmin?

Posted on 2010-11-11
3
Medium Priority
?
665 Views
Last Modified: 2012-05-10
Experts,

I am using phpMyAdmin v. 2.7.0 and I have a column which uses auto_increment.  I've been testing some php functionality and now the auto_incrament column is up to 20000+.  I'd like to restart the numbering back to 0...is this possible?

Any help would be much appreciated.  Thanks.

EVM
0
Comment
Question by:evibesmusic
3 Comments
 
LVL 6

Accepted Solution

by:
CyberGhost earned 1000 total points
ID: 34116040
truncate the table... I don't believe there is any other way, as altering it would possibly create duplicate primary keys
0
 
LVL 61

Assisted Solution

by:HainKurt
HainKurt earned 1000 total points
ID: 34116265
rename the old one, create a new table...
0
 

Author Closing Comment

by:evibesmusic
ID: 34116317
Good to know.  Thank you to both of you for your insight...easy points.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
The viewer will learn how to dynamically set the form action using jQuery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question