- Posts: 41
- Thank you received: 0
Reset #__jd_donors 'id' to zero
- Dave
- Topic Author
- Offline
- Senior Member
-
Less
More
7 years 1 week ago #117166
by Dave
Reset #__jd_donors 'id' to zero was created by Dave
Hello.
I imported a 100-member csv test database.
Then later I deleted all members, modify table structure, import again.
Each time I import, 'id' value begins at ending value of previous import, even though I delete all members before fresh import.
How do I reset 'id' value to zero so that fresh import begins at member #1 instead of member #301?
Thanks!
I imported a 100-member csv test database.
Then later I deleted all members, modify table structure, import again.
Each time I import, 'id' value begins at ending value of previous import, even though I delete all members before fresh import.
How do I reset 'id' value to zero so that fresh import begins at member #1 instead of member #301?
Thanks!
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13255
- Thank you received: 1729
7 years 1 week ago #117174
by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Reset #__jd_donors 'id' to zero
Hi Dave,
ID column is auto increasement field, we aren't able to reset it to zero (from start)
Thanks
Dam
ID column is auto increasement field, we aren't able to reset it to zero (from start)
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Dave
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 41
- Thank you received: 0
7 years 1 week ago #117180
by Dave
Replied by Dave on topic Reset #__jd_donors 'id' to zero
Run phpMyAdmin.
Open site database.
Open table _jd_donors.
Click Operations tab.
Scroll down to AUTO_NCREMENT field.
Reset value to desired starting value for 'id'.
Thx.
Open site database.
Open table _jd_donors.
Click Operations tab.
Scroll down to AUTO_NCREMENT field.
Reset value to desired starting value for 'id'.
Thx.
Please Log in or Create an account to join the conversation.
Moderators: Dang Thuc Dam, Dang Dam
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.