[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 655
  • Last Modified:

How to reset an auto_increment column to 0 using phpMyAdmin?

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
evibesmusic
Asked:
evibesmusic
2 Solutions
 
CyberGhostCommented:
truncate the table... I don't believe there is any other way, as altering it would possibly create duplicate primary keys
0
 
HainKurtSr. System AnalystCommented:
rename the old one, create a new table...
0
 
evibesmusicAuthor Commented:
Good to know.  Thank you to both of you for your insight...easy points.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now