MSQL

Code to rest Auto Increment in MYSQL ADMIN::

1 Choose Databse:
2 Then click SQL Tab and Enter code.
3 Change {employee to the table to change:

If List is Populated:

set @autoid :=0;
update employee set id = @autoid := (@autoid+1);
alter table employee Auto_Increment = 1;

If Table is empty you only need the following code:
alter table employee Auto_Increment = 1;