Hi,
MySQL locks work only until a session expries, so they will not be of much use
in your case. The best solution will be to implement this logic in your
application - the simplest method is to add a field to the table which will
keep the information about whether the specific record is locked
Hi there.
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
In the last episode (Sep 07), Rich said:
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