Re: Locking Methods

2005-09-08 Thread Dobromir Velev
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

Re: Locking Methods

2005-09-07 Thread Dan Nelson
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