•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 401,446 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,924 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 2676 | Replies: 4
 |
•
•
Join Date: Aug 2004
Posts: 22
Reputation: 
Rep Power: 5
Solved Threads: 1
Newbie Poster
hi, im in the middle of a situation where i have an auto incriment primary key and i need to change its value back to zero
any ideas ?
any ideas ?
•
•
Join Date: Feb 2005
Posts: 354
Reputation:
Rep Power: 4
Solved Threads: 12
Posting Whiz
If you empty (TRUNCATE) the table it will go back to zero.
•
•
Join Date: Mar 2004
Posts: 717
Reputation:
Rep Power: 6
Solved Threads: 29
Master Poster
If you try to reset just the primary key, you'll run the risk of having repeated numbers unless the table is truncated and wiped out completely.
•
•
Join Date: Feb 2005
Posts: 354
Reputation:
Rep Power: 4
Solved Threads: 12
Posting Whiz
An update on this. I have just found out that TRUNCATE `table`; works on MyISAM databases for MySQL to reset the autoincrement value, but not neccessarily other types. It does NOT work on InnoDB types.... If you want to change the table type in MySQL you can do this:
Then it will be easier to modify or reset the autoincrement value.
ALTER TABLE `database_name`.`table_name` TYPE = MYISAM;
Then it will be easier to modify or reset the autoincrement value.
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Random unique primary key - is this possible? (MySQL)
- generate unique primary key (MySQL)
- Primary Key Issue (Visual Basic 4 / 5 / 6)
Other Threads in the PHP Forum
- Previous Thread: Arrays in PHP
- Next Thread: Question about ASp or Php
