Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

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

Reset DataObject ID to zero / AUTO_INCREMENT


Reply


396 Views

Avatar
CHD

Community Member, 218 Posts

25 January 2012 at 3:58am

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.