Solved

How to reset an auto_increment column to 0 using phpMyAdmin?

Posted on 2010-11-11
3
646 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 250 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 51

Assisted Solution

by:HainKurt
HainKurt earned 250 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Object's Property 9 22
How to load 2 images in same column in Delphi 2 32
Update from TABLE-A to TABLE-B 5 38
use lov values 2 29
Read about achieving the basic levels of HRIS security in the workplace.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will learn how to dynamically set the form action using jQuery.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now