I want to set the initial value to a primary key which is also set to the auto increment option such as it begins from the value 7899 in mysql?

Question

In mysql, I want to set the initial value to a primary key which is also set to the auto increment option such and it begins from the value 7899?

score 0 · Accepted Answer · answered Aug 27 '16 at 08:19

0

From documentation:

ALTER TABLE table AUTO_INCREMENT=7899;

answered Aug 27 '16 at 08:19

Alexey Soshin

1 Answers1