I have a INNODB table with txnno column without unique index but I have primary key on another column. Now I am inserting transaction from multiple places. And there are some concurrent insertion happening for same txnno.

So Is there it is required to use txnno as unique key or INNODB can have it implicitly.

And there is two type of entry. Form one place, I am using commit/rollback statment but there are some places Where I am not using that.

So how can I manage this without changing much code.

Also what is meant by 'no sessions' in the case of table locking.

  • Create UNIQUE (not primary) index by this column simply. And there is two type of entry. This is separate and independent task.
    – Akina
    Feb 25, 2021 at 8:52
  • Show us SHOW CREATE TABLE and a sample INSERT. What you ask for is possible, but I want the actual column names to show you how.
    – Rick James
    Feb 27, 2021 at 1:06


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.