MySQL Forums
Forum List  »  InnoDB

Re: how to change innodb_autoinc_lock_mode = 0
Posted by: matthew Baynham
Date: April 09, 2021 10:51AM

I'm running Opencart and when someone buys something from me I have create an invoice. The invoice numbers don't skip but the order numbers do skip.

When my account and the tax office here in Germany see missing orders they will ask where is the VAT on the missing orders, and they will ask me what the hell is going on.

I can't change the way Opencart gets the order numbers so I need to make sure that the auto increment doesn't skip any values.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to change innodb_autoinc_lock_mode = 0
632
April 09, 2021 10:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.