www.webdeveloper.com
+ Reply to Thread
Results 1 to 3 of 3
  1. 07-06-2008 05:38 AM #1
    chestertb's Avatar
    chestertb
    chestertb is offline Privateer and Brigand
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    700

    What Happens When A Table Is Locked?

    Hi All,
    I want to know what happens when a table is locked (aside from the obvious).
    Specifically, let's say I lock a table and another user tries to access the table. Does mysql just wait until the table is unlocked, or does it return some form of error?
    Thanks
    CTB
    Oh Lord, please help me be the person my dog thinks I am.
    Reply With Quote Reply With Quote
  2. 07-06-2008 12:19 PM #2
    chazzy's Avatar
    chazzy
    chazzy is offline Working class hero
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    it waits.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time
    Reply With Quote Reply With Quote
  3. 07-06-2008 04:19 PM #3
    chestertb's Avatar
    chestertb
    chestertb is offline Privateer and Brigand
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    700
    thanks chazzy. much appreciated.
    Oh Lord, please help me be the person my dog thinks I am.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 HTML5 Development Center



Recent Articles