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(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? I think LOCK IN SHARE MODE will work, if you want to lock the rows in table2 which the join touches. But better test it with 2 connections. > -- > Have a nice day. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
