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

[@WordPressWisdom]

Saved me the stress of setting new auto increment and importing again a record of over 900K. Thank you. Thank you! Indeed learning never stops.

[@mijail619]

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

[@deepak_4ever_485]

Thank You much. 👍

[@susmantobealivebruh4238]

Thank you brother

[@himajpatil]

Thanks a lot

[@sarbjitsingh9687]

thank you

[@CharlesXavier-gb9bs]

you saved

[@infernogaming9504]

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

[@hafsasifeddine9198]

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

[@HarithaComputersTechnology]

No worries!

[@terrillchristians]

thanks excellent video- i used the first formula to change the current records ensure the new records created would follow that number sequence

[@HarithaComputersTechnology]

Glad it helped!

[@GaneshBisoi-tm2lm]

Thank you so much sir for this video.

[@kingprince1860]

Merci, j'ai galéré un moment avant de tomber sur ta solution

[@JamesBond-gw7hc]

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

[@jayasuriya4194]

thank you for your answer.big helpful for this video.

[@joydeepbhattacharjee5305]

thank u so much sir...very helpful video

[@abrar4093]

thanks allot sir ...
this is very helpfulllllllllllllllllllllllllllllllllllllllllllllll

[@stiveroncal2735]

greeting from Peru THANK YOU

[@gcastelt_ideas_libertarias]

thank you! Greetings from Venezuela

[@davileo5392]

tnx homey u saved ma time

[@liftedup299]

Thank you for helping me!

[@ramiro041]

thank you, it work without a hitch

[@feryelaco7320]

thank you! Greetings from Panama

[@loicnicolas4598]

fine, but how can you do it automatically for a project, for example?

[@HarithaComputersTechnology]

The same procedure you have implement, just change the connection string according to your remote database thanks

[@Twowheeleetales]

thanks sir

[@clipfarma]

Thank You Sir You Reduced My Stress 💗💖🥺

[@HarithaComputersTechnology]

No worries !

[@soumikbasu6510]

thanks for the help

[@freelancertahsan9403]

It's Working! Thank you so much!

[@playinggaming1509]

thank you

[@McMaEl24]

Thank you! Helped so much!

[@gautamkumar-if5yf]

Thanks alot to give such solution..

[@tejasjadhao4963]

I have done as you instructed and then after last alter command I deleted the row and again inserted row but the same problem is coming

[@HarithaComputersTechnology]

It works 100% please check your datatypes and the column contains primay key or not..

[@thedevcristian]

Thank you! Stay safe

[@jawadlee273]

Very Helpful to me......

[@mrdsmind5908]

THANKS

[@pipettta]

Absolutely usefull, thanks a lot mate!

[@bimsarasenarath2665]

Thankz. Its worked.

[@ahmedmahfadi1631]

Thank you very much for this video.

[@HarithaComputersTechnology]

Thanks mate !

[@bennylee3145]

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

[@ramiro041]

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

[@matthewthemobiledj]

Big Thanks from England

[@HarithaComputersTechnology]

Thanks mate !

[@محمدمطاوع-ل2ل]

Great job
thank you

[@dennischarles4384]

Thanks indeed!

[@mohammadsulaibi9]

thanks very much

[@HarithaComputersTechnology]

No worries!

[@1966Ally]

Thank you, lifesafer!

[@phiwayinkosivictor2890]

Thank you soo much

[@raghavaggarwal2418]

pls tell me agr mai koi bhi record del krta hun toh automatically ids update hojaye aisa kuch bta sakte ho

[@ekkkogo2413]

Nice thank you Sir

[@HarithaComputersTechnology]

Thanks mate !

[@shivay4573]

Thank you sir

[@HarithaComputersTechnology]

thank you sir

[@carlosmaralit2397]

thank you very much very helpful :)

[@HarithaComputersTechnology]

No worries mate!

[@hungcao1342]

nice !

[@vazap9026]

Thank you!

[@HarithaComputersTechnology]

u r welcome mate !

[@jhayjhayidmilao5612]

thankyou bro

[@HarithaComputersTechnology]

Thanks mate !

[@Barijj17]

Thank you so much buddy

[@tutorialsonly4654]

Thanks man it helped!

[@HarithaComputersTechnology]

Thanks mate ..!

[@zaidkureshi8587]

informative

[@kogashinto2123]

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

[@business1442]

better~❤

[@tibeyisaac7431]

Please I want to keep old records and restart auto ID 1. How do I do that ?

[@kumaresha3348]

How to make id restart after deleting middle record in C# with MySQL.

[@consoledoterror971]

What if this table has relation with other. Won't it going to be a big mess.

[@thealchemist8212]

Sir in my database, subs_id always start with serial number 0, so the next entry data could not be filled, what should I do sir???

[@landofabraham]

Stop the Illegal War in the name of Peaceful War worldwide. Control your Americal. Mike 😕

[@mesajjadnadir]

thank you :)

[@HarithaComputersTechnology]

thanks mate :)

[@palalopea592]

thanks xoxo :D

[@HarithaComputersTechnology]

Thanks mate!

[@pedhmaplakaielf]

I try it on phpmyAdmin it work! but when I try it on SQLI mysqli_query isn't they said You have an error in your SQL syntax.
what I do something worng plese halp me.
$q = "DELETE FROM plants WHERE pro_id='$pro_id';
SET @autoid :=0;
Update plants set pro_id='$pro_id' = @autoid :=(@autoid+1);
alter table plants Auto_increment =1";
$result = mysqli_query($dbcon,$q);

[@bnr_sports]

any solution

[@anggiawanprasetyo8609]

Thankyou :)

[@HarithaComputersTechnology]

thanks mate !

[@destoniusdhiraviam4643]

How to use this query in php.?

[@bnr_sports]

any answer

[@cengusanadorsito]

Thanks (Y)

[@tejasjadhao4963]

Still I m having same problem

[@xx0bb]

Warning: #1287 Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'.
how to type code then ?

[@jonathancostantini7189]

how to execute this in c#?

[@cryptobuzzz8703]

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

[@palalopea592]

how about in sqlite? please help me

[@asc_chimuarufa]

Real Challenge. Same Problems Every Time
We know that we can "always" reset the auto-increment column
BUT
eventually, you will have the same problem again and again.
Question.
Can you make an auto-reset auto increment?
FOR EXAMPLE
ID NAME
1 BOB
2 JOHN
3 SERA
#1 delete some users
ID NAME
1 BOB
3 SERA
#2 add a new user
1 BOB
3 SERA
4 MIKE
use the manual auto-increment reset
Then the same issue happens again. (See for example)
Is there any way that the database can auto-reset the auto-increment so the problem will not happen again?

[@muhammadshahrukhsiddiqui8155]

did you get the answer yet? if you do, can you please share it.....

[@asc_chimuarufa]

@@muhammadshahrukhsiddiqui8155 I still can't figure it out how. Sorry

[@asc_chimuarufa]

@Gustavo Saiki ik, but how

[@Twowheeleetales]

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

[@gudiputisairam346]

i got this error Pleases Help Some:(
Error
SQL query:
update loginapp set id = @autoid := (@autoid+1)
MySQL said: Documentation
#1146 - Table 'loginapp.loginapp' doesn't exist

[@bnr_sports]

$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

[@fmgraphicdesign76]

Thanks a lot

[@HarithaComputersTechnology]

Thanks mate !

[@dragoljubbrajovic9337]

Thank you !!