[Ahmad45123]

Quote:

Originally Posted by TwinkiDaBoss 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.

Am pretty sure running this SQL should reset all the numbers from 1.

Код:

ALTER TABLE tablename AUTO_INCREMENT = 1

Make sure to not run that on every insert though just run it only once, This code rebuilds the whole table so if you have a huge one, it might take ages.