How To Reset Table Auto Increment Column Id In MySQL (PHPMyAdmin)

If i use this statement with servlet that would work ? After deleting specific data ?

thank you so much for this tuto i can't believe that you released this life saver 6 years ago .

Will the row being in auto increment and correct serial numbers?

Thank You Sir You Reduced My Stress 💗💖🥺

Thank you so much sir for this video.

$query= "DELETE FROM ".$tableName." WHERE ".$conditionData SET @autoid :=0; UPDATE live SET id = @autoid := @autoid+1; ALTER TABLE live AUTO_INCREMENT = 1;



any one pls correct it

SET @autoid :=0;
UPDATE table_name SET id = @autoid := (@autoid+1);
ALTER TABLE table_name Auto_Increment = 1;

thanks allot sir ...
this is very helpfulllllllllllllllllllllllllllllllllllllllllllllll

set @autoid :=0;
update `show` set showid = @autoid := (@autoid+1);
alter table `show` Auto_Increment = 1;

Thank you for helping me!

How to restore posts from phpmyadmin after being deleted permanently from trash?

It's Working! Thank you so much!

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

thanks sir

better~❤

it would be very usefull if you include the code in the description so as to copy paste it

thank you, it work without a hitch

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

you don't use DBCC CHECKIDENT(tableName, RESEED, 0) ?