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