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


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


Sorry, only registered users may post in this forum.

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.