Reset cases number

**ddallago** · 2006-12-28, 02:16 PM

Can I reset cases number? Because every year I want to start again from number 1.
Thanks to all can give me an help.

**kpit** · 2006-12-28, 02:23 PM

what about the cases from the prior year that may have not closed yet? do they carry over to the next year? There would be a serious consistancy problem with that method.

**rymfiltre** · 2009-04-03, 04:32 PM

Hi
i don't know if you had solve your problem but i give you my solution and you will use it if needed
in phpmyadmin or any other mysql client and execute the request "ALTER table "your table name AUTO_INCREMENT=0"
that is all :-)

**Angel** · 2009-04-03, 05:50 PM

In addition to Max's comments...resetting it to zero means you have to move the older records from the table as the number has to be unique.

If you already have records 1 - 100, then reset the auto increment without getting rid of those records first, you won't be able to enter a new record because the new record #1 will conflict with the already existing record #1 from before the reset.