Reset #__jd_donors 'id' to zero

  • Dave
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
6 years 3 months 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!

Please Log in or Create an account to join the conversation.

More
6 years 3 months ago #117174 by Mr. Dam
Replied by Mr. 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

Please Log in or Create an account to join the conversation.

  • Dave
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
6 years 3 months 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.

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamDũng Nguyễn Việt