MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:November 19 2005 2:10pm
Subject:Re: what function could detect a row locked by other client ?
View as plain text  
Hello.

This is not exactly what you want, but it might be helpful:
  http://dev.mysql.com/doc/refman/5.0/en/show-open-tables.html


>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
wang shuming wrote:


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
what function could detect a row locked by other client ?wang shuming19 Nov
  • Re: what function could detect a row locked by other client ?Rhino19 Nov
  • Re: what function could detect a row locked by other client ?Gleb Paharenko19 Nov