InnoDB shared lock with JOINs

2002-12-05 Thread Evgeny Chuykov
Hallo. I have this query: SELECT table1.id FROM table1 LEFT JOIN table2 USING(id) WHERE table1.a=1 and table2.b=1 table1 is MyISAM and table2 is InnoDB. I want a shared mode lock on the table2. Is it possible, or i should split this query? -- Have a nice day.

Re: InnoDB shared lock with JOINs

2002-12-05 Thread Heikki Tuuri
Evgeny, - Original Message - From: Evgeny Chuykov [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, December 05, 2002 12:28 PM Subject: InnoDB shared lock with JOINs Hallo. I have this query: SELECT table1.id FROM table1 LEFT JOIN table2 USING