CODEWITHSUNDEEP
mysqlincrement
rushi kulkarni
rushi kulkarni

Reputation: 79

reset autoincrement starting point

I am having the following issue :

I have database where I auto increment the user id's starting from 001. Now, that I have completed 100 users, I want to auto increment the further id's from 1000 for some reasons.

How is it possible? Thanks in advance.

PS : I am using MYSQL, PHP and phpmyadmin.

Upvotes: 0

Views: 68

Answers (1)

Abhijit Maity
Abhijit Maity

Reputation: 467

ALTER TABLE your_table
MODIFY some_column INT NOT NULL AUTO_INCREMENT;

OR

ALTER TABLE tablew_name CHANGE id id BIGINT(20) NOT NULL AUTO_INCREMENT;

OR

Select the A_I check box when creating/editing a column from your phpmyadmin UI.

Upvotes: 1

Related Questions