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

Top 10 ChatGPT Prompts to Learn Anything 10x Faster

Introduction Learning has been transformed by artificial intelligence, which provides resources that enable you to…

2 weeks ago

Discover the Ultimate Tool for Frontend Designers and Developers

Introduction Even experienced developers may find it difficult to create aesthetically pleasing and useful web…

2 weeks ago

Git Tag Cheat Sheet

Introduction Git tags are an essential feature of version control systems, offering a simple way…

5 months ago

Understanding Web Storage: Cookies, Local Storage

Introduction The methods that browsers employ to store data on a user's device are referred…

5 months ago

Setting up OpenVPN Access Server in Amazon VPC – AWS

Introduction A well-known open-source VPN technology, OpenVPN provides strong protection for both people and businesses.…

5 months ago

Enhance Error Tracking & Monitoring: Integrate Sentry with Node.js & Express.js

Introduction Integrating Sentry into a Node.js, Express.js, and MongoDB backend project significantly enhances error tracking…

6 months ago