|List:||General Discussion||« Previous MessageNext Message »|
|From:||N!||Date:||May 28 2014 9:26am|
|Subject:||How to get a S-lock in a Transaction|
|View as plain text|
Hi: I tried to get a S-lock using following SQL: 1. start transaction; SELECT * FROM test.t1 where id=1; But I found this way does not work. I changed it as following: 2. start transaction; SELECT * FROM test.t1 where id=1 lock in share mode; I am wondering why the first way does not get a S lock?
|• How to get a S-lock in a Transaction||N!||28 May 2014|