how to reset autonumber primary key (auto number) on program

danels · Post by **danels** » Wed May 14, 2014 5:55 pm

how to reset autonumber primary key (auto number) on program?

i have created the program. and im doing trial and debugging. but when i do this. the primary key autonumber is increasing. so i want to reset the program start autonumbering from 1 again.

i meant the auto number begin from number 1. i have changed in the phpmyadmin database for the number start from 1 again.
but the program is filling the auto number primary key continuing from before value.

any idea how to solve this. Thanks in Advance

scs · Post by **scs** » Wed May 14, 2014 6:23 pm

The AI field is the primary key (that means UNIQUE and NO DUPLICATE)

If you want to set it back to 1, you need to delete all records from the table. Most simple way is TRUNCATE the table. It will move the counter back to 1.