I am trying to change my Invoice increment ID through MYSQL table Current Invoice ID is 000000002, I want to start next invoice Id from 200000001 So want to add "2" at the start of invoice ID,

When I am trying to change in the MySQL table sequence_invoice_1 it's showing me an error: "can't copy the table to the same one"

So can anyone Suggest me, what is the correct way to change increment id of Invoice!

enter image description here

1 Answer 1


You are supposed to click the Go button from Table Options instead of Copy table to(database.table) that's why you are getting that error.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.