Categories: My SQL

Reset the auto increment value for a MySQL table

The following example changes the auto increment value for the table named “applytable” to 100. This means that the next time you insert a record into this table the value of the auto incremental primary key will be 100.

If the highest value for the column is already greater than 100 then it will be set to the highest value plus 1.

ALTER TABLE mytable AUTO_INCREMENT = 100
 

The relevent info are highlighted with red circles in the screenshot below.

Developer Diary

Share
Published by
Developer Diary

Recent Posts

Laravel vs Node Js: Which One Is Good For What?

Introduction In the world of web development, selecting the correct framework is critical. Laravel and…

3 months ago

Docker Cheatsheet: Essential Commands and Explanations

Introduction By enabling containerization, Docker has transformed the way software is built, deployed, and managed.…

8 months ago

Difference between Memcached and REDIS – Secrets of Caching

Introduction Speed and efficiency are critical in the ever-changing world of web development. Effective caching…

8 months ago

How to Revert a Git Commit: A Simple Example

Introduction Git, a popular version control system in software development, enables developers to track changes,…

8 months ago

What is Git Stash and Why Do You Need It

Introduction Are you tired of grappling with tangled changes and unfinished work while using Git?…

8 months ago

Difference between git stash pop and git stash apply

Introduction Version control is essential in software development because it ensures that changes to a…

8 months ago