I started a different thread on this, but then I realized I might not have
to use InnoDB for this.
Let me explain what I wish to achieve.
I want to create records in an established table. I then want them locked
(either by locking the whole table or by individual record) so that they
cannot be updated or deleted.
I am concerned that locking a table won't allow me to add new records. I
also need the records fully viewable.
Which table format should I choose, and how do I implement this? I've
reviewed some of the alternatives, and they got all confusing to me.
15.11.3 InnoDB and Transaction Isolation Level indicates that READ COMMITTED
is what I should be looking for, but it refers to an index that I'm unaware
of, as nothing is indexed.
Any leadership appreciated.