Hi, I know select .. update could lock selected rows, if the connection not release the lock, others always wait. If I use get_lock() to get a logical lock by key xxxtable+xxxrow , but others may not update other database on the same server . What function could detect a row locked (by select ... update) by other client ? Best regard! Shuming Wang
- what function could detect a row locked by other client ? wang shuming