Table Locking in MySQL

W

wxdqz

New Member
As there is no concept of Record locking in MySQL, Table has to be locked. If a Table is locked by one user, what happens to the other user who is accessing the table at that precise moment. Both are trying for a write access. What if the table is locked for more than a stipulated time. How should the script be written so that the other table who does not get write access waits.

Please shed light some light on the above problem...

Best Regards
 
You must log in or register to reply here.
Back
Top