what about in MySQL?,
I would like the locking query should work for the following scenario,
1) Having one DB connection
2) lock some rows by one
thread 3) using the same connection lock some other rows by the second thread
4) release the lock aquired by the first thread, during this lock relase the second lock should not get relased
5) release the lock aquired by the second thread
is there any row level readlock or writelock exist in MySQL?