MySQL Forums
Forum List  »  InnoDB

Re: how to change innodb_autoinc_lock_mode = 0
Posted by: Peter Brawley
Date: April 14, 2021 10:45AM

> I need to make sure that the auto increment doesn't skip any values.

Auto_increment cannot guarantee strict sequentiality, only uniqueness. I'm not familiar with OpenCart, but if you need strict order number sequentiality and OpenCart doesn't provide it, you'll need to either add it or find better software.

Options: ReplyQuote

Written By
Re: how to change innodb_autoinc_lock_mode = 0
April 14, 2021 10:45AM

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.