e lock there are and how they relate to each other. Is there any way I can get
both types of lock in one go, in the first statement I execute?
Thanks,
David
Tobias Asplund <[EMAIL PROTECTED]> wrote:
On Wed, 6 Oct 2004, David Edwards wrote:
> I've got a deadlock problem using Inn
Hi,
I've got a deadlock problem using InnoDB tables in MySQL 4.1.5 for win32. I have two
tables, 'jobs' and 'results', where 'results' has a foreign key 'id_job' that
references the primary key of 'jobs'. There may be more than one result for any given
job. Both tables have a single auto_incre