28.11.2015, 02:26
How do I reset SQL AUTO_INCREMENT?
Aka how do I make it start from 0 again after Ive deleted many stuff from it
Example:
ID 1 Account
ID 2 Account
ID 3 Account
and now I delete them all, but it continues doing
ID 4 Account
ID 5 Account
While the 1,2,3 are empty.
I want to basically reset that so it starts from 0 again
I got AUTO_INCREMENT & PrimaryKey set as ID
EDIT: Sorry for double post, was accident.
Aka how do I make it start from 0 again after Ive deleted many stuff from it
Example:
ID 1 Account
ID 2 Account
ID 3 Account
and now I delete them all, but it continues doing
ID 4 Account
ID 5 Account
While the 1,2,3 are empty.
I want to basically reset that so it starts from 0 again
I got AUTO_INCREMENT & PrimaryKey set as ID
EDIT: Sorry for double post, was accident.