Resetting an Auto increment field

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
JamesBrown
Posts: 16
Joined: Thu 28 Apr 2011 23:41

Resetting an Auto increment field

Post by JamesBrown » Fri 23 Dec 2011 16:29

Is it possible to get a 'do over' on the autoincrement field of a table?

After having trouble importing data into a table and doing it over and over the field became very large. I would like to reset it before releasing it.

Thanks......... Jim

alexa

Post by alexa » Mon 26 Dec 2011 09:05

Hello, Jim.

We suggest you to do the following:

1. Right-click the table in Database Explorer and select 'Edit Table' from the popup menu.
2. Switch to the 'Options' tab.
3. Modify the value of the 'Auto increment' field
4. Save the table's changes.

Post Reply