How to set Auto Increment to one 1 even after deleting records. PhpmyAdmin ( Php my admin)
1)Go in your PhpmyAdmin database.
2)Select your database.
3)Open your Table whose id you want to reset.
4)go to Operations tab on that table.
5)Scroll all the way down, You will find two options
a) Truncate the table b)Delete the table
6)Click on Truncate the table and after that go on the SQL tab of your table and enter the following line.
"ALTER TABLE xyz AUTO_INCREMENT=1"
=============================================
The issue that comes up when you delete a record and primary key is messed up again
Solution: After deleting row place this query
DELETE FROM table_name WHERE id=xyz
ALTER TABLE table_name AUTO_INCREMENT = 1
Watch video How to set Auto Increment to one 1 even after deleting records. PhpmyAdmin ( Php my admin) online without registration, duration hours minute second in high quality. This video was added by user Code Combination 02 February 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 54,785 once and liked it 266 people.