)
mysql commit;
Query OK, 0 rows affected (0.00 sec)
mysql
Client 2:
mysql delete from table1
- where id=3;
Query OK, 1 row affected (22.33 sec)
mysql
From: Bill Easton ([EMAIL PROTECTED])
Subject: InnoDB lock in share mode on union
This is the only article
How do I lock rows in a union query so that I know they won't change during
the rest of my transaction?
I want to do the following query, using LOCK IN SHARE MODE:
(select id from table1 where id 1)
union
(select id from table2 where id 1);
If I try:
(select id from table1