Jump to:

23483 Posts in 18976 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Reset DataObject ID to zero / AUTO_INCREMENT

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 341 Views
  • CHD
    Avatar
    Community Member
    218 Posts

    Reset DataObject ID to zero / AUTO_INCREMENT Link to this post

    Was searching around here for how to reset IDs in the database to 0 to remove test uploads.
    Couldn't find it here, but it's just a basic SQL query: ALTER TABLE `tablenamegoeshere` AUTO_INCREMENT =0

    Obviously you'll want to delete all the objects first.

    Hope this is helpful to some.

    341 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.