In MySQL, I have a table, and I want to set the
auto_increment value to
5 instead of
1. Is this possible and what query statement does this?
This question is related to
You can use
ALTER TABLE to change the auto_increment initial value:
ALTER TABLE tbl AUTO_INCREMENT = 5;
See the MySQL reference for more details.