0

How can I change the value of the ID in a MySQL table, for example, to "9999," while keeping the remaining IDs (1-315) unchanged and ensuring that the next autoincrement value is actually set to "316" and not "10000"?

First I made this command: UPDATE table SET id = 9999 WHERE id = 5;

Then I made this command: ALTER TABLE table AUTO_INCREMENT = 316;

But the next autoincrement was again 10000

Improve this question
3
  • 2
    Why on earth would you want to?? P.S. This has nothing to do with PHP, I changed your tags. Commented May 23, 2023 at 13:10
  • Why not just keep the next ID as 1000? What's the issue with that? It's just an arbitrary number. Commented May 23, 2023 at 13:29
  • As explained in one of the linked questions, you can only do that if you remove the large IDs first: dbfiddle.uk/Y2MgUApP - Otherwise, you'll eventually break future inserts. Commented May 23, 2023 at 13:50
Related questions
1671
How to reset AUTO_INCREMENT in MySQL
3215
Should I use the datetime or timestamp data type in MySQL?
3327
How to add a column with a default value to an existing table in SQL Server?
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.