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
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 InnoDB tables
(...)
Transaction 1:
START