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


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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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