Re: how to change innodb_autoinc_lock_mode = 0
> 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.
Subject
Views
Written By
Posted
1697
April 09, 2021 02:32AM
772
April 09, 2021 10:34AM
632
April 09, 2021 10:51AM
Re: how to change innodb_autoinc_lock_mode = 0
595
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.